Enter 100 in an empty cell.

Select the range of numbers and in place EditPaste SpecialDivideOKEsc.

Format to Currency

Delete the 100 from the cell.


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 09:11:00 -0700, jopat205
wrote:

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