Different result when copy data from MS Outlook to MS Excel


Our colleagues reported an odd behavior when copying data from MS Outlook message body to MS Excel.  The main difference is one the treatment of formated numeric figures.  One PC will result in numeric treatment in Excel while the other one when doing the same, Excel will treat it as text.

Both PCs are installed with Windows XP sp3, MS Outlook 2003 and MS Excel 2007.  MS Office are up to latest patch.  Email messages are using HTML to display message content and use MS Word as the editor.

When copying a TABLE of data from the email message to Excel, one will result in treating the formated numeric figure as text while another one will treat as numeric figures.  Both are copying from the same email. Both result in Excel are with the formating maintained.  While only one can use the figure to calculate (without any need to convert).

May I know whats wrong with the PC that result in treating the figure as text in Excel?

Who is Participating?
JohnBusiness Consultant (Owner)Commented:
Try doing an Excel repair on the problem PC. Open Excel, go to the Trust Center, then Privacy Options and select (check) the flag to "Download a file periodically from Microsoft". Exit Trust Center and then Help, Diagnostics and run the diagnostics. This should reset any settings that affect Paste.  It would appear the problem PC may always be pasting as text (Paste Special)

See if that helps and let us know. ... Thinkpads_User
Jackie ManCommented:
For both PCs, goto "Control Panel" -> "Regional and Language Setting"s and check whether the date format is the same

Excel will lookup the date settings in Regional and Language Settings to determine whether a number for date value is actually a date or now. By default, the date format is MM/DD/YYYY for Windows XP asthe language is set to be English (US).
StanleyLMWAuthor Commented:
Need both solutions in order to solve the case.  Thanks a lot. ^^
JohnBusiness Consultant (Owner)Commented:
Thank you and thanks for the update.  Thinkpads_User
Jackie ManCommented:
Glad to know you have solved the problem.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.