View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default 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