Different result when copy data from MS Outlook to MS Excel
Posted on 2012-08-16
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?