| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
4 digits required for a number
In cell, suppose I have a number 32 & I want it to be in 4 digits like 0032;
for 7-0007; for 200-0200 (It should not change its form from number to Text) How to write the formula? Pls help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of digits in a number | Excel Worksheet Functions | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| adding digits of a number | Excel Worksheet Functions | |||
| "A valid number is required" | Excel Discussion (Misc queries) | |||
| help with removing digits from a number | Excel Discussion (Misc queries) | |||
Threaded Mode
