number formatting \ Millions to ones

[vjharry]

Hello,

As per attached file can we change number formatting for numbers (Thousands to ones) for eg like may we see 450,000 as 4.5 ?

Any Quick help will be appreciated.

Thanks,
Vijay

 

[Rick Rothstein]

As long as you leave the height of the row at the standard size, you can use this trick to display the number the way you want. Select the cell and then call up the "Format Cells" dialog box... select the Number tab and then select "Custom Format" and type this in the Type field...

0.0,,,%%

then put the text cursor between the last comma and first percent sign and press CTRL+J (the percent signs will look like they disappeared)... then click the "Alignment" tab and put a check mark in the "Wrap text" checkbox... finish off by clicking the OK button.

 

[vjharry]

its working in cells ... but not working in charts at number formatting

 

[Rick Rothstein]

its working in cells ... but not working in charts at number formatting

You didn't say anything about charts (and this forum does not allow attachments, so whatever you did that made you think you attached a file did not work). Sorry, but I have very little experience with charts, do I cannot help you there. Hopefully someone with the necessary experience will come along and help out.