leading 0 - concatenate -zip- needs a fix

  • Thread starter Thread starter Robinson
  • Start date Start date
R

Robinson

Hello, just upgraded to excel 2002 (part of office XP update) Working in
windows me,

I need to have the leading 0 show in a cell (1800 of them) as part of the
zip code.
It shows in the cell but will not copy or import to a word file, unless I do
a concatenate. Then paste special the formula as values.

I want it to work as it should or rather did in the older version -can
anyone suggest a fix,

PLEASE

Wanda
 
Have you tried formatting the cells as text? Copy & paste
then transfers to Word.

Arkimediz
 
Highlight the data that contains the Zip code. Then goto format cells
click on special and there are built in choices for Zip-code and Zip+4
that will add the leading 0's
 
Back
Top