A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do i get Excel not to drop my 1st zero (02360)



 
 
Thread Tools Display Modes
  #1  
Old August 10th 07, 07:00 AM posted to microsoft.public.excel.worksheet.functions
Yaesu Man
external usenet poster
 
Posts: 1
Default How do i get Excel not to drop my 1st zero (02360)

I have been trying to type in zip codes that begin with the number 0 in the
the 1st number. How do I get it to stay in there?
Ads
  #2  
Old August 10th 07, 07:04 AM posted to microsoft.public.excel.worksheet.functions
OssieMac
external usenet poster
 
Posts: 2,510
Default How do i get Excel not to drop my 1st zero (02360)

Format the cells as text

Regards,

OssieMac



"Yaesu Man" wrote:

> I have been trying to type in zip codes that begin with the number 0 in the
> the 1st number. How do I get it to stay in there?

  #3  
Old August 11th 07, 11:03 PM posted to microsoft.public.excel.worksheet.functions
Steve G
external usenet poster
 
Posts: 44
Default How do i get Excel not to drop my 1st zero (02360)

On Aug 10, 2:00 am, Yaesu Man <Yaesu >
wrote:
> I have been trying to type in zip codes that begin with the number 0 in the
> the 1st number. How do I get it to stay in there?


I would go to format--cells--custom. In the rectangle below "type:"

enter 0##### - #### (do not put in the blank spaces--I am just
showiing it this way so you can read it) if you are using the full zip
code.

If you are using the 5-digit zip code, type 0#####

Then click okay. Format all cells like this that have a 5 digit zip
code or 9 digit zip code and not lose a digit if zero is the first
digit.

Steve G

  #4  
Old August 6th 08, 02:53 PM posted to microsoft.public.excel.worksheet.functions
apj
external usenet poster
 
Posts: 1
Default How do i get Excel not to drop my 1st zero (02360)

Ihave tried formatting the column before I start typing my zip codes and that
works great, however I have a list typed up already highlighting then
changing it to text does not work... how do I format a list I have typed
already to show the 0.

"Yaesu Man" wrote:

> I have been trying to type in zip codes that begin with the number 0 in the
> the 1st number. How do I get it to stay in there?

  #5  
Old August 6th 08, 03:03 PM posted to microsoft.public.excel.worksheet.functions
Beege
external usenet poster
 
Posts: 66
Default How do i get Excel not to drop my 1st zero (02360)

apj,

I maintain that zipodes are not numbers, because no calculations will be
done with them.

That said (phew),

format/cells/custom "00000" could work for you, except if you're using
both 5 and 9 digit zips. I'm sure there are other posts giving you a
good solution for both scenarios, like a column with:

=IF(A1 > 99999, TEXT(A1,"00000-0000"), TEXT(A1,"00000"))

Or something...

Beege

apj wrote:
> Ihave tried formatting the column before I start typing my zip codes and that
> works great, however I have a list typed up already highlighting then
> changing it to text does not work... how do I format a list I have typed
> already to show the 0.
>
> "Yaesu Man" wrote:
>
>> I have been trying to type in zip codes that begin with the number 0 in the
>> the 1st number. How do I get it to stay in there?

  #6  
Old August 6th 08, 03:13 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,389
Default How do i get Excel not to drop my 1st zero (02360)

The same way you format cells prior to entering data.

Right click on the cell, choose Format Cells..., enter a format of 00000.
To copy this format quickly, right click on the fill handle, drag down,
release the mouse button, and choose Fill Formatting only.

Regards,
Fred.

"apj" > wrote in message
...
> Ihave tried formatting the column before I start typing my zip codes and
> that
> works great, however I have a list typed up already highlighting then
> changing it to text does not work... how do I format a list I have typed
> already to show the 0.
>
> "Yaesu Man" wrote:
>
>> I have been trying to type in zip codes that begin with the number 0 in
>> the
>> the 1st number. How do I get it to stay in there?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a drop-down list along with an auto-populate drop-down CrazyLostConfused Excel Discussion (Misc queries) 1 April 17th 07 12:10 AM
Create new drop down from previous drop down selection Supe Excel Discussion (Misc queries) 3 January 19th 07 10:26 PM
how do I link a drop down list entry to a new drop down cell? lmunzen Excel Discussion (Misc queries) 1 August 15th 06 04:59 PM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 02:43 PM.


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