number formatting difficulties

[mathchick]

Hi all,

Hopefully someone else is better with number formatting than me. I'm trying to format a version number without using text (it creates that crappy looking -- error number stored as text, and it's a number so I'd like it to be one).

The closest I've gotten is custom format #,###.######## but here's what I get
1.03 displays as 1.03
1 displays as 1.

I would like to get rid of the decimal point. Thanks in advance for any takers!

 

[Andrew Poulsom]

For the example numbers you posted what's wrong with the General number format?

 

[mathchick]

wow, I feel like a bit of an idiot. No idea why I didn't try that. Thanks!

 

[mathchick]

Ha! I figured out what that didn't work. Sometimes the version is 1.0, sometimes it's 1.03 (this is a generic spreadsheet used to create various tools with different versioning systems. What I'd like to find is a format which can display any of the following

1.10
1.03
2
4.7

The problem lies in the number of digits because version 4.7 is FAR different from version 4.70

Any help or suggestions would be greatly appreciated.

 

[Andrew Poulsom]

Do you mean it should be 4.07? As far as I am aware there isn't a number format that will show 2 decimal places only if the number is not an integer.

 

[mathchick]

I figured as much, but figured I'd ask just in case there was a way to do it. Back to text number format. Thanks!