Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2011, 06:27 AM
salin salin is offline How can I retain Zero's (0) in front of #'s in Office 2010 Windows 7 64bit How can I retain Zero's (0) in front of #'s in Office 2010 Office 2010 64bit
Novice
How can I retain Zero's (0) in front of #'s in Office 2010
 
Join Date: Dec 2010
Posts: 19
salin is on a distinguished road
Default How can I retain Zero's (0) in front of #'s in Office 2010

I have product numbers that have zero's in front of them such as (00104). I've tried formatting the cells on the Excel worksheet using "numbers" and "custom", but I can't get the zeros to remain after hitting "enter".


Office 2010
Reply With Quote
  #2  
Old 02-10-2011, 07:32 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How can I retain Zero's (0) in front of #'s in Office 2010 Windows 7 32bit How can I retain Zero's (0) in front of #'s in Office 2010 Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

If the numbers are always five digits then you could use a custom format of 00000

Else, your options are to begin the number entry with a ' or to format the cells as text before entering the numbers.

Hope that helps...
Reply With Quote
  #3  
Old 02-10-2011, 07:42 AM
salin salin is offline How can I retain Zero's (0) in front of #'s in Office 2010 Windows 7 64bit How can I retain Zero's (0) in front of #'s in Office 2010 Office 2010 64bit
Novice
How can I retain Zero's (0) in front of #'s in Office 2010
 
Join Date: Dec 2010
Posts: 19
salin is on a distinguished road
Default

Thanks..............the custom format was just what I was looking for.
Reply With Quote
  #4  
Old 11-16-2022, 07:18 AM
Juna93 Juna93 is offline How can I retain Zero's (0) in front of #'s in Office 2010 Windows 11 How can I retain Zero's (0) in front of #'s in Office 2010 Office 2021
Novice
 
Join Date: Nov 2022
Posts: 4
Juna93 is on a distinguished road
Default

Consolidate information with the Ampersand image (and) Select the cell where you need to put the joined information. Type = and select the principal cell you need to join
Reply With Quote
  #5  
Old 11-16-2022, 09:22 AM
ArviLaanemets ArviLaanemets is offline How can I retain Zero's (0) in front of #'s in Office 2010 Windows 8 How can I retain Zero's (0) in front of #'s in Office 2010 Office 2016
Expert
 
Join Date: May 2017
Posts: 770
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

Quote:
Originally Posted by salin View Post
Thanks..............the custom format was just what I was looking for.
Are you sure about this?
Code:
I have product numbers that have zero's in front of them such as (00104)
I suspect you get those product numbers from some other source (ERP system, Web site, ...?). Those number having such format indicates, that those a really text values. I.e. this product number in source is really "00104".
Having a cell formatted so it displays leading zeros doesn't change the value in cell. I.e. when you entered the number 104 into some cell, and formatted it to display 00104, then the value there is really 104. And this is not equal with "00104"! It depends really on your data on sheet, are you getting some problems later because this, or not!

Btw, in case you have in your source product numbers "00104! and "104" (i.e. those are different products there), and you copy those product numbers into Excel cells formatted as general, those product numbers are converted to numbers, and both get numeric value 104!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I retain Zero's (0) in front of #'s in Office 2010 Outlook 2003 will not retain password TRSmith Outlook 8 12-08-2014 07:17 PM
Upgraded from Office 2007 to Office 2010, now can't open Outlook MDuff Outlook 2 01-27-2011 01:06 PM
How can I retain Zero's (0) in front of #'s in Office 2010 Outlook Question When Migrating From Office 2007 To Office 2010 swassociates Outlook 3 01-01-2011 07:39 PM
License Office Standard 2010 and Home and business 2010 papypaul2 Office 0 11-05-2010 08:55 AM
MSWord Placeholders Bug; replaced pics don't retain position za105 Word 0 01-23-2009 10:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft