| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I convert copied Text numbers into values in Excel?
Copied spreadsheet from third party program to create formulas. However,
numbers were inserted as TEXT "144,116,991.10" but the quotes only show when reviewing values in the formuls error. Need to know how to covert this text into a number. |
|
#2
|
|||
|
|||
|
did you try this
select empty cell. edit-copy goto the cell containing number-text edit-pastespeical in pastespecial window under operation click <add and ok it. MOE wrote in message ... Copied spreadsheet from third party program to create formulas. However, numbers were inserted as TEXT "144,116,991.10" but the quotes only show when reviewing values in the formuls error. Need to know how to covert this text into a number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Linear Mode
