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!
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!
Last edited: