 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007Inserting Number
How do i insert number "Zero 0" in front of multiple numbers 7775644619 7764856857 7932085127 7828206664 7917806074 7973667607 Thanks Karen Custom format (Formatting>Cells>Custom) of 00000000000  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > How do i insert number "Zero 0" in front of multiple numbers > 7775644619 [quoted text clipped - 7 lines] > > Karen This appears to work but the zero does not actually exsist ie not in FX Box when copy and paste it does show zero, Thanks Karen > Custom format (Formatting>Cells>Custom) of 00000000000 > [quoted text clipped - 9 lines] >> >> Karen Then it won't be a number that Excel recognizes as a number, it would be text. You can use a help column for that =TEXT(A1,"00000000000") copy as needed, then copy and paste special as values SignatureRegards, Peo Sjoblom > This appears to work but the zero does not actually exsist ie not in FX > Box [quoted text clipped - 17 lines] >>> >>> Karen Your data must be Text numbers not actual numbers. Data >> Text to Columns >> Next >> Next >> Finish Custom Format cells as 00000000000 > This appears to work but the zero does not actually exsist ie not in FX Box > when copy and paste it does show zero, [quoted text clipped - 16 lines] > >> > >> Karen Karen The formatting just changes the appearance, not the value. If you want the value changed you could use a helper cell with a formula. ="0" & A1 Drag/copy down then Copy>Paste Special>Values>OK>Esc. The values are now text with a preceding 0 Gord Dibben MS Excel MVP >This appears to work but the zero does not actually exsist ie not in FX Box >when copy and paste it does show zero, [quoted text clipped - 16 lines] >>> >>> Karen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.