| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers
When I tried Biff's suggestion: =A1*100 then formatted the cells as
CUSTOM and 000000000, the format would change to SPECIAL. When I tried Ragdyer's suggestion: =TEXT(A1*100,"000000000"), the format did not change and I got the results I needed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert numbers to time | Excel Discussion (Misc queries) | |||
| convert letters to numbers | Charts and Charting in Excel | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
