Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert text format to numeric
I have a very large spreadsheet with #'s in most cells. Many are manually
entered but others are calculated. It appears that some of the cells containing manually entered data, have been entered (or converted) into text format rather than numeric format. The cells that contain formulas involving these text formatted cells are skipping them because of the format. Is there any easy way to convert large blocks of text formated #'s to numeric format? I think this should be easy but can't figure it out. None of the text formated #'s have an apostrophe in front. They all have a small green mark at the top left corner of the cell. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert a numeric number in text format in another cell? | Excel Worksheet Functions | |||
How do I convert numeric data to string format (without VBA)? | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
convert text to numeric vba add-in? | Excel Worksheet Functions | |||
convert numeric to text | Excel Worksheet Functions |