Green Arrow, Access to Excel, Convert en masse?

  • Thread starter Thread starter +Bob+
  • Start date Start date
B

+Bob+

Access 2002, converting data from Access to Excel, numeric data shows
up with the horrid green arrows.

I can change these one by one, but is there some way to change a whole
column of these entries at once? Changing them one by one is way
beyond annoying.

Thanks,
 
Format all to General.

Copy an empty cell.

Select the range of data and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 
Format all to General.

Copy an empty cell.

Select the range of data and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
Click to expand...


OK! So far so good, the numbers are really numbers now. Now I have the
vise-versa problem - zip codes that have the little arrow. I've tried
formatting as "Text" but it still keeps the green arrow.

Is there a way to fix those also?

Thanks
 
Your original post mentioned "numeric data" only, not zip codes.

Did you include those in the paste special>add operation?

You should not have.

What does the green arrow dropdown options think is the problem with the zip
codes?

Inconsistent formula? Number stored as text?


Gord
 
Your original post mentioned "numeric data" only, not zip codes.
Did you include those in the paste special>add operation?
You should not have.
Click to expand...

No, they came over that way.
What does the green arrow dropdown options think is the problem with the zip
codes?
Inconsistent formula? Number stored as text?
Click to expand...


"The number in this cell is formatted as text..."

(Duh, that what I want :-)

It only occurs on the 5 digit zip codes (00000). The nine digit
(00000-0000) are fine.
 
Back
Top