Number needs decimal place and comma added

[jdino73]

HI
I have a column of numbers and need to add decimal and comma
Example
110400 should be 1104.00 - computer thinks this is 110400.00 - which is incorrect - Can a formula be written to have end result 1,104.00

another issue
13800000 should be 138.00

I would be so grateful if a formula can be provided to correct these two items
Thank you you in advance

 

[Joe4]

I think your rules need to be clarified/nailed down a bit better.
You said:

110400 should be 1104.00

13800000 should be 138.00

So then how do you know where the decimal point should go?
Will all numbers zeroes after the decimal, so all trailing zeroes can be dropped from the whole number (and made a decimal)?

But if that were true, how would a number like "100" be represented, and how can you tell it from "1" or "10"?
i.e. how would you know if "10000" should really be "100.00", "10.00", or "1.00"?

 

[jdino73]

Ok - I see I made it confusing - Can i edit ?

Is there a formula to take 110400 to 1104.00 - basically any number in this column the last two digits are the change
Sorry I am not conveying this correct

 

[Joe4]

Simply divide by 100!