LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Covert loyus 123 to Excel spreadsheet lewarthur Excel Discussion (Misc queries) 3 July 24th 07 05:04 PM
covert excel to access files TimR Excel Discussion (Misc queries) 2 February 22nd 07 06:23 PM
How does excel automatically covert cells when a different number. talil Excel Discussion (Misc queries) 1 March 17th 05 06:49 AM
covert quattro pro to excel with microsoft office xp ? steveni5991 New Users to Excel 0 February 24th 05 03:01 AM
How to covert old Lotus 123 files with .123 extension to Excel? Kate Excel Discussion (Misc queries) 2 January 31st 05 06:51 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"