|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 10th, 2007, 07:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
August 10th, 2007, 07:04 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 11th, 2007, 11:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 6th, 2008, 02:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 6th, 2008, 03:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 6th, 2008, 03:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
