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? |
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) |