Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number stored as text
I have number stored as text. It has a small green triangle at the upper
left of the cell. If I click on the cell it has a yellowsign with a ! and if I click on that a menu and "convert to number" This works fine one cell at a time. I need to convert columns the cell format has no effect on the column of cell I need to change. I did un click the protect on the last tab. Suggestions? Sueanne |
#2
|
|||
|
|||
copy an empty cell.
select your range of offending cells Edit|paste special|check Add sueanne wrote: I have number stored as text. It has a small green triangle at the upper left of the cell. If I click on the cell it has a yellowsign with a ! and if I click on that a menu and "convert to number" This works fine one cell at a time. I need to convert columns the cell format has no effect on the column of cell I need to change. I did un click the protect on the last tab. Suggestions? Sueanne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |