don't believe that formatting can do this (probably wrong <<vbg>>)
anyway in an adjacent cell enter
Left(a1,5) and copy down where a1 is your 98221-9879
HTH
-----Original Message-----
Can I format a column of zip codes listed 98221-9879 to
read 98221?
Howeth?
.
YEs to format a cell or group by clicking the left mouse
button on the cell, or by clicking on the first cell in
the group and dragging until all of the desired cells are
included within the selection. once all cells are in the
selection, release the mouse button. select cells from the
format menu and the window illus above will be displayed
which is (special) click and category provides the ability
to format cells for zip code etc.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
