Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"Convert to Number" option disappearing
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! |
#2
|
|||
|
|||
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 "Mike" wrote: 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! |
#3
|
|||
|
|||
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? "Ray A" wrote: 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 "Mike" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i convert the number 1 as 01 or 001 in excell cell | Excel Worksheet Functions | |||
How can I convert a date into a week number... | Excel Worksheet Functions | |||
convert number to text and format it. | Excel Worksheet Functions | |||
convert number into corrseponding text | Excel Discussion (Misc queries) | |||
how can i convert a number in words? | Excel Discussion (Misc queries) |