coverting numbers format

J

jopat205

information was imported into a program. The numbers need to be converted to
currency. I am forgetting the route to take on this. trying the usual format
command obviously doesnot work.
Example 15208825 should be 152088.25
 
G

Gord Dibben

Enter 100 in an empty cell.

Select the range of numbers and in place Edit>Paste Special>Divide>OK>Esc.

Format to Currency

Delete the 100 from the cell.


Gord Dibben MS Excel MVP
 
Top