"Convert to Number" option disappearing

M

Mike

When I have a lot of data that I want to use the "convert to Number", the
pop-up with the "exclamation mark inside the yellow diamond" disappears.

Essentially, I want to highlight 1 column, but 5 screens worth of data,
using SHIFT-PAGEDOWN. However, when I go past one screen, the yellow diamond
does not consistenly appears. I need this so that I can use the "convert to
number" functionality".

Any ideas on how to make this appear, or is there another way to "convert to
number"?

Thanks for any ideas!
 
R

Ray A

Hi Mike,
In a helper cell enter the number 1. Copy that cell and then paste
special/multiply into the cells you want to convert.
HTH
ray
 
M

Mike

Thanks Ray! This worked like a charm. Any other ideas on how to do this, so
that I can hopefully train a simpler solution to others?
 
Top