coverting numbers format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jopat205 - 20 May 2008 17:11 GMT

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

Reply to this Message

Mike H - 20 May 2008 17:31 GMT

Hi,

=A1/100

Mike

> 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

Reply to this Message

Gord Dibben - 20 May 2008 18:56 GMT

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

>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

Reply to this Message