Is there a way to suppress digits to the right of the decimal place and suppress the decimal place if none?

[JenniferMurphy]

Is there a custom format that will display 1 or more significant digits to the right of the decimal place and will suppress the decimal point if there are none?

I want to be able to use a single custom format, like "0.###" to get this effect:

Is that possible? If so, how?

 

[RoryA]

No - you would need a conditional format for that.

 

[JenniferMurphy]

No - you would need a conditional format for that.

Could you provide an example?

I did find this solution:

Format a number with optional decimal places in Excel

I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any. For exampl...

superuser.com

It works, but it requires two columns.

I'd like a way to be able to enter the data and have it formatted and displayed in the same cell -- while retaining the original value.

 

[RoryA]

Actually, looking at your example, General format would do what's in your picture.

 

[JenniferMurphy]

Actually, looking at your example, General format would do what's in your picture.

I figured out what the problem is. After your comment, I tested it again. I first tried it in a new workbook. It worked. I then tried it in a new sheet in the workbook in question. It worked. I then tested it on a different cell in the same sheet. Some cells worked and some didn't. Then I realized that the problem was the column width. Excel was rounding to fit the cell.

Doh!

Thanks