 |
 | 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 / General Excel Questions / March 2008How to add a zero infront of a number
How do I add a zero infront of a number. For example I want the number to be read like this: 012 But i type in excel it shows up as 12. CYNTHIA Place an apostrophe first then your number (the apostrophe will not show on the sheet but will be seen in the formula bar), or formate the cell as text. Mike Rogers > How do I add a zero infront of a number. > [quoted text clipped - 3 lines] > > But i type in excel it shows up as 12. this is fast and works > CYNTHIA > [quoted text clipped - 10 lines] > > > > But i type in excel it shows up as 12. But if you want it to still behave as numeric, you could apply the custom format of "0"0 to those cells. Rob > this is fast and works > [quoted text clipped - 14 lines] >> > >> > But i type in excel it shows up as 12. Thanks for your help. > But if you want it to still behave as numeric, you could apply the custom > format of "0"0 to those cells. [quoted text clipped - 19 lines] > >> > > >> > But i type in excel it shows up as 12. CYNTHIA Glad you got it sorted out, thanks for the feed back!! Mike Rogers > this is fast and works > [quoted text clipped - 12 lines] > > > > > > But i type in excel it shows up as 12. Try Format Cells -> Custom. Enter 000.  SignatureHTH, Barb Reinhardt > How do I add a zero infront of a number. > [quoted text clipped - 3 lines] > > But i type in excel it shows up as 12. > How do I add a zero infront of a number. > [quoted text clipped - 3 lines] > > But i type in excel it shows up as 12. If what you want is always to display three digits (with any necessary leading digits showing zero), format the cell as 000. select the cells and go to format cells(ctrl+1) and select "number" tab select the custom. give 000 in "type" option box. > How do I add a zero infront of a number. > [quoted text clipped - 3 lines] > > But i type in excel it shows up as 12. Thank you for your help it worked. > select the cells and go to format cells(ctrl+1) and select "number" tab > select the custom. [quoted text clipped - 7 lines] > > > > But i type in excel it shows up as 12. Either format the cell as text before you enter the number, or Format the cell as 000 if you want it to be 3 digits, or Use a helper column with the formula ="0"&A1 The 1st & 3rd suggestions leave the cell as text, so you couldn't use it for calculations; the 2nd would still be a number. SignatureDavid Biddulph > How do I add a zero infront of a number. > [quoted text clipped - 3 lines] > > But i type in excel it shows up as 12. |
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.