Possible??

S

snickers22

In one column, I have numbers with two decimal points, i.e. 55.42. In the
next column I need to take the decimal point out and add to zeros like this
"005542". Anyone know if there is a function that would do this?
 
J

JE McGimpsey

If you want text:

B1: =TEXT(A1*100,"000000")

If you want numbers:

B1: =A1*100

and use a Custom Format: 000000
 
D

David Billigmeier

=A1*100 then:
<Format><Cells>
Click on "Custom"
Enter: 000000

However, doing it using the above way will not actually have the 2 prefixed
zero's in the cell, it will just look that way because of the format. To
physically have the 2 prefixed zero's in the cell use:

=TEXT(A1*100,"000000")

or, If the numbers are always 2 digits, then a decimal point, then 2 digits:
="00"&left(A1,2)&right(A1,2)
 
Top