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

[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?

 

[Ron de Bruin]

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.

 

[Doug]

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

 

[Florence]

-----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.

Then click on format, then cells, then text.
This will show you zip codes starting with "0".

Florence