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

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

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

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
 
F

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.
Click to expand...
Then click on format, then cells, then text.
This will show you zip codes starting with "0".

Florence
 
Top