| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I change number format from 3,999.89 to 399989
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I change number format from 3,999.89 to 399989
You cannot format that number in the manner you ask.
Multiply the cell by 100 to get your wish. Enter 100 in an empty cell. Copy that cell then select the cells with numbers and paste specialmultiplyesc Delete cell with 100 Gord Dibben MS Excel MVP On Wed, 7 Apr 2010 20:48:01 -0700, MichelleT wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| Hoe to change text format .126 to number format 0.126 | Excel Discussion (Misc queries) | |||
| How to change text format .126 to number format 0.126 ? | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
