Positioning the decimal point?

  • Thread starter Thread starter Ron
  • Start date Start date
R

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.
 
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
 
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
Click to expand...

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.
 
Ron said:
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.
Click to expand...
Format | Cells | Number | 2 decimal places displays 0.00

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

Bill
 
Back
Top