Last 2 digits to treat as the decimal point

[lemuel]

Hi,

Can you help me figure this out. revenue numbers are in whole numbers with which the last 2 digits are supposed the tenth and hundreths place. See below.

for example 1022900 = to rewrite as 10229.00. Can we instruct excel to rewrite such like this?

[tigeravatar]

lemuel,

I think this is what you're looking for:
http://office.microsoft.com/en-us/ex...16499.aspx#BM3

[haru]

format cell to have 2 decimal places, divide all the cells by 100.

Please Login or Register  to view this content.

[darknation144]

If you have received a satisfactory solution please mark this thread as solved.

[lemuel]

thank you all.