| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using numbers as numbers in a cell having text
In a spreadsheet I have headings for blood-test values (i.e. RBC, WBC, etc.).
The values below sometimes have text after to indicate the value is (L) - low, or (VL) - v. low, such as: "23.5 (VL)". Is there a way to use the values in cells that have text as values, that is to always ignore text and treat numbers within as numbers. There are many, many other spreadsheets where this ability w/b very beneficial. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| How do I format a cell with numbers, text and hyphens | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
Threaded Mode
