formal cell - limit zip code to 5 digits

  • Thread starter Thread starter Susan
  • Start date Start date
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
Click to expand...
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.
 
Back
Top