| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Numbers
Here's what I have: Spreadsheet with column of currency that was formatted
as "text". I inserted a column to the right - put in formula =" "&A1 and the numbers then appears as numbers (without the little green tab in the corner). Then I wanted to delete the first column but can't because formula refers to it. I inserted a third column, copied 2nd column and paste special (values) but the text tab reappears. Is there some way to eliminate the original text column or copy the second column and keep it formatted as just number or currency? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
