Working with a spread sheet to show names, address, etc.

  • Thread starter Thread starter Betty Cea
  • Start date Start date
B

Betty Cea

While working with a spread sheet to develop a roster
when I have a zip code to enter that begins with a 0 such
as 08842 the program refuses to show the zero and
continually drops it. Is there a way to rectify this
problem?
 
Hi Betty

Format your cell as text before you enter the codes
(Select the cells and use Ctrl-1 and on the number tab choose text)

Or type a ' before the code.
 
Select FORMAT on the Menu, CELLS, NUMBER tab. From the
NUMBER tab, select SPECIAL in the Category window. In the
Type window, select ZIPCODE. Then press ENTER.

doug
 
-----Original Message-----
While working with a spread sheet to develop a roster
when I have a zip code to enter that begins with a 0 such
as 08842 the program refuses to show the zero and
continually drops it. Is there a way to rectify this
problem?
.
Using mouse, left click on column with zip codes.
Click to expand...
Then click on format, then cells, then text.
This will show you zip codes starting with "0".

Florence
 
Back
Top