| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
coverting numbers format
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
coverting numbers format
Hi,
=A1/100 Mike "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
coverting numbers format
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Coverting the cells into general | Excel Worksheet Functions | |||
| coverting h:mm to decimal | Excel Discussion (Misc queries) | |||
| Coverting seconds into hr:min:sec | Excel Discussion (Misc queries) | |||
| Coverting time | Excel Worksheet Functions | |||
| coverting rows to columns | Excel Worksheet Functions | |||
Linear Mode
