Format Cells - 45,600 to show as 45.6

[gossv]

Hello,

I am trying to format figures such as 45,600 to show as 45.6.

In format cells there is the custom option to use ##0.0E+0 but that actually reads as 45.6E+0. This is the closest that I have found.

Any suggestions?

Thank you

Ginny

 

[SydneyGeek]

Hi Ginny,

Try this. #,##0.0,

The ending comma rounds by thousands. Two commas rounds by millions, etc.

Denis

 

[gossv]

Thanks Sydney Geek,

That is exactly what I wanted~!