number formatting difficulties

mathchick

Active Member
Joined
Mar 21, 2012
Messages
337
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! :)
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

mathchick

Active Member
Joined
Mar 21, 2012
Messages
337
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Active Member
Joined
Mar 21, 2012
Messages
337
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! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,650
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top