Different result when copy data from MS Outlook to MS Excel

Posted on 2012-08-16
Last Modified: 2012-08-21

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?

Question by:StanleyLMW
    LVL 89

    Accepted Solution

    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
    LVL 40

    Assisted Solution

    by:Jackie Man
    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).

    Author Closing Comment

    Need both solutions in order to solve the case.  Thanks a lot. ^^
    LVL 89

    Expert Comment

    by:John Hurst
    Thank you and thanks for the update.  Thinkpads_User
    LVL 40

    Expert Comment

    by:Jackie Man
    Glad to know you have solved the problem.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
    Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now