Figures needs to be shown in Lacs

[spycein]

Hi All,

I want to format a cell in such a way that it should shows figures as if particular figure is divided by one hundred thousand.

for example ( if I type 120000 it will show 1.20, similarly 546789 = 5.47)

I want to format a cell like that and not to put any formula in the cell.

The content of the cell should remain the same i.e. 120000 or 546789 but it should visible as 1.20 or 5.47 and if i prepare any chart from the data it should show in the 1.20 or 5.47 format only.

For Example : (if I )

Format - Cell - Custom = Result
100000 - cell - 0, = 1

Similarly I want to format the cell in such a way that it should give above display.

Thanks

 

[oldbrewer]

I would use a hidden helper cell - however I will watch for other answers with great interest.....

 

[Michael M]

I was thinking a Worksheet_Change macro to divide any inserted number ....I'll watch too !!

 

[BGY23]

Format the cell as below. But remember any formulas dependant on these cells will treat them as 000's and not as they appear. What you are doing is changing the appearance of the contents and not the contents


#,###.00,;[Red]-#,###.00,