ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2002: How to convert MS Outlook table back to numbers ? (https://www.excelbanter.com/excel-discussion-misc-queries/221395-excel-2002-how-convert-ms-outlook-table-back-numbers.html)

Mr. Low

Excel 2002: How to convert MS Outlook table back to numbers ?
 
Hi,

Occasionally I need to copy an Excel table previously pasted on the Outlook
e-mail body to Excel worksheet for data analysis.

Usually, I find that I could not do anything with the numbers in the table.
Any formula associated with those cells returns with #VALUE.

I failed to use format cell General or Numbers to convert it back to values.

Neither could I do it by using Text to Column function.

Appreciate very much if someone could show me the way.

Thanks

Low




--
A36B58K641


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com