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 |
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 |
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 |
All times are GMT +1. The time now is 10:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com