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

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 505

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2002 : Unable to open files in MS Outlook 2002	Mr. Low	Excel Discussion (Misc queries)	1	June 29th 07 02:12 PM
Convert Pivot table back to Data Table	Samaa	Excel Discussion (Misc queries)	2	March 21st 07 10:02 AM
Excel 2002 : Convert Positive Numbers to Negative Numbers ?	Mr. Low	Excel Discussion (Misc queries)	2	November 6th 06 03:30 PM
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl	scampbell	Excel Worksheet Functions	0	February 22nd 06 06:31 PM
In Excel how do I convert back from having row and column NUMBERS.	Willem Duyvesteyn	Excel Discussion (Misc queries)	1	February 15th 05 06:41 PM

All times are GMT +1. The time now is 06:04 AM.

Menu

About Us