coverting numbers format

  • Thread starter Thread starter jopat205
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Long Numbers as Text cells 1
hyperlinks stop working in PDF format 1
Format appears stuck..how to break formatting 2
Currency without a $ 6
Help on conversion 3
Dates coverted to formulas 3
Currency autofit 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top