"Convert to Number" option disappearing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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?
 

Ask a Question

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.

Ask a Question

Similar Threads

Change text to numbers 2
Status Bar: SUM function doesn't work for numbers copied from web 4
Macros & "Convert to Number" 5
Difficult text to number conversion 4
Excel 2007 paste data, need to convert to numbers 3
How to convert text to number? 9
Convert Number to words 1
Convert Text to Number 1

Back
Top