Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a set of data that are numbers stored as text. CLicking on the little
green tab enables me to convert the text in the cell into a number. All The data in the column starting from a certain row and ending at a certain row are numbers stored as text. Also, it's a very long long long list. Is there a shortcut to converting all the data to numbers without having to click the green tab for each cell or having to highlight all the cells in the column (only to zip past the last row) and go through cell properties? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |