adding decimal places

[excel_2009]

hi excel gurus,

quick question, i've the following values:


54999
127557
45956
27999
169999
17999
15999
11999
19999


but want them displayed like this:


549.99
1275.57
459.56
279.99
1699.99
179.99
159.99
119.99
199.99

i've clicked on the deicmal formatting however the values have 00 added to them

anyone?

 

[rallcorn]

Quick way:

In separate cell enter 100 & copy it,
Highlight your column of numbers & paste special, divide

 

[excel_2009]

Quick way:

In separate cell enter 100 & copy it,
Highlight your column of numbers & paste special, divide

Hi Rallcorn,

thank you for the suggestion, it works however i need to retain the number with the decimal places aswell, is that possible?

thank you

 

[Gerald Higgins]

If your data starts in A1....


=a1/100

 

[excel_2009]

If your data starts in A1....


=a1/100

Cheers Gerald, my minds turned to mush today!