| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
each number in cell should be 10 digit
I am getting numbers in excel from a database..i want that each number should
be 10 digit and if less than ten digit then it should be preceded by 0 (zeros) to make it 10 digit number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
each number in cell should be 10 digit
To keep the numeric value but show 10 digits, Format Custom as 0000000000
To get a 10-character text string: =TEXT(A1,"0000000000") -- Kind regards, Niek Otten Microsoft MVP - Excel "Vipul" wrote in message ... |I am getting numbers in excel from a database..i want that each number should | be 10 digit and if less than ten digit then it should be preceded by 0 | (zeros) to make it 10 digit number. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
each number in cell should be 10 digit
On Thu, 2 Nov 2006 03:01:02 -0800, Vipul
wrote: I am getting numbers in excel from a database..i want that each number should be 10 digit and if less than ten digit then it should be preceded by 0 (zeros) to make it 10 digit number. Format the cells as: Format/Cells/Number/Custom Type: 0000000000 --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions | |||
| excel - numbers as text | New Users to Excel | |||
Hybrid Mode
