Positioning the decimal point?

[Ron]

I have data that is being imported from an external source
as a general field.

The data in the import TXT file looks like 00124561
There is no physical decimal point but this
represents a DOLLAR value of $1,245.61

No matter what I do Excel INSISTS on displaying this as 124561.00
I've tried all kinds of number formats, custom formatting, etc. Nothing works.

How do I get this to display and calculate with the decimal
point where *I* want it.
Changing the input to add a physical decimal point is NOT an option.

Thank You.

 

[Peo Sjoblom]

Assuming that an amount like $1,245.00 would look like 00124500
put 100 in an empty cell, copy it, select the import range, do edit>paste
special, select divide
format as currency

 

[Ron]

Assuming that an amount like $1,245.00 would look like 00124500

put 100 in an empty cell, copy it, select the import range, do edit>paste
special, select divide
format as currency

Thank you. That seems like a very odd way doing it but whatever.
One problem. Some of the dollar amounts are zero. 00000000
How do you get this to display as .00 not just 0.

Thank You.

 

[Bill Sharpe]

Thank you. That seems like a very odd way doing it but whatever.
One problem. Some of the dollar amounts are zero. 00000000
How do you get this to display as .00 not just 0.

Format | Cells | Number | 2 decimal places displays 0.00

Format | Cells | Custom | type in ".00"(without quotes) displays .00

Bill