Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert 9 digits to 10 in excel
I have a series of numbers in an Excel column. Some are 9 digits long and
need a zedro added to the front to make them 10 digits. I know there is a formula I can place in a column next to them which will convert them but I don't know what it is. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert 9 digits to 10 in excel
Hi Lisa,
Try this. =TEXT(A1,"0000000000") You could also apply a custom format of 0000000000 to the existing cells. HTH Martin "Lisalala" wrote in message ... I have a series of numbers in an Excel column. Some are 9 digits long and need a zedro added to the front to make them 10 digits. I know there is a formula I can place in a column next to them which will convert them but I don't know what it is. Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert 9 digits to 10 in excel
If you want only to display leading zero, then custom format the cells with
format code "0000000000" (ten zeros). If you want to store 10 digit numbers as text (e.g. a kind of codes) then enter =TEXT(A1,"0000000000") in an empty helper column (adjust cell reference A1 to your real situation), copy the helper column and PastSpecial/Values it back to the original column! Regards, Stefi €˛Lisalala€¯ ezt Ć*rta: I have a series of numbers in an Excel column. Some are 9 digits long and need a zedro added to the front to make them 10 digits. I know there is a formula I can place in a column next to them which will convert them but I don't know what it is. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Covert loyus 123 to Excel spreadsheet | Excel Discussion (Misc queries) | |||
covert excel to access files | Excel Discussion (Misc queries) | |||
How does excel automatically covert cells when a different number. | Excel Discussion (Misc queries) | |||
covert quattro pro to excel with microsoft office xp ? | New Users to Excel | |||
How to covert old Lotus 123 files with .123 extension to Excel? | Excel Discussion (Misc queries) |