Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Leading 0's disappear
Ok, heres my dilema, I deal with a lot of serial numbers, many of which begin
with a 0, and well it is very time consuming to go through and enter '0 infront of all of them. Is there any way to turn off the auto-correct feature that gets rid of leading zeros in my cells? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Leading 0's disappear
Let's say you have already entered data in A1:A10
Put in B1: ="0"&A1 Copy down to A10. Then copy B1:B10, paste over A1:A10 with a paste special as values. This "restores" the leading zero to the data at one go. Clear B1:B10. For new data entries, just pre-format the range as TEXT before you enter the data -- Max Singapore http://savefile.com/projects/236895 Downloads:18,100 Files:360 Subscribers:56 xdemechanik --- "Nick" wrote: Ok, heres my dilema, I deal with a lot of serial numbers, many of which begin with a 0, and well it is very time consuming to go through and enter '0 infront of all of them. Is there any way to turn off the auto-correct feature that gets rid of leading zeros in my cells? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Leading 0's disappear
Hi,
First the answer to your question - no. But besides concatenating a leading 0 as already suggested, you might be able to handle your problem with a format. If 1. all entries are the same length, say 5 characters, then you can create the custom format 00000. You do this by choosing the command Format, Cells, Number tab, Custom and entering 00000 on the Type line. 2. This method would also address the problem if you wanted all numbers displaying 5 digits but some of them only had 1 non-zero digit, such as "9". The above format would display as 00009. -- Thanks, Shane Devenshire "Nick" wrote: Ok, heres my dilema, I deal with a lot of serial numbers, many of which begin with a 0, and well it is very time consuming to go through and enter '0 infront of all of them. Is there any way to turn off the auto-correct feature that gets rid of leading zeros in my cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gridlines disappear | Excel Discussion (Misc queries) | |||
Links disappear | Links and Linking in Excel | |||
How do I make it disappear? | New Users to Excel | |||
New formula ## does not disappear | Excel Discussion (Misc queries) | |||
Add-Ins disappear | Setting up and Configuration of Excel |