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. |
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. |
All times are GMT +1. The time now is 12:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com