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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
4 digits required for a number
Select the range you want to show four digits, go to Fomrat Cells, Choose
Custom and in the Type box enter 0000 (that is four zeroes) as the format and you are set. "Sandeep" wrote: 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 |
Reply |
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) |