Format Conversion

J

james.szumigata

Hello,

I have the value of $27.52...I need to convert it into 00002752.


Any help would be greatly appreciated
 
D

Dave Peterson

Formatting can't change the value from 27.52

But you could use another cell:

=text(a1*100,rept("0",8))
or
=text(a1*100,"00000000")
 
B

Bernard Liengme

To retain the original (say in A1) use =A1*100 and format with Custom format
00000000
To make permanent change:
1) type 100 in an empty cell and copy it
2) select cell(s) with dollar value and use Edit | Paste Special _> multiply
3) delete cell with 100
4) format the cell(s) as above
best wishes
 
Top