Formatting Currenty - decimal places

  • Thread starter Thread starter JTF
  • Start date Start date
J

JTF

Hi

I know this is going to be very easy, but I am stumped.

I have imported text into a worksheet. The numbers are displaying like
this:
100000
86517
125087

(Note: on the actual worksheet, they are right aligned as they should
be).

I need them to display like this:

1000.00
856.17
1250.87

In other words, the decimal should be in front of the last two digits
of the number. Whenever I try to format them, however, Excel does
this:

10000.00
85617.00

etc.

What am I not seeing? Much thanks!
 
Changing the format won't change the value.

And 86517 is 86,517.

You could use a helper cell with a formula like:

=a1/100

and format that as a number with 2 decimal places.

Then convert it to values and delete the original column????
 
Back
Top