Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have recently upgraded to Excel 2003 from 2000 . I am exporting data from
a business application which imports it directly to Excel. When the data is opened the the number formatting in two columns look like this: T4151xt (value in cell 9/29/4151) T2182xt (value in cell 6/25/2182) The numbers should be: 822434 103176 This is not a problem when the data is exported to Excel 2000 version - the numbers look fine. I have to reapply the number format to get the correct data to display. Is there a setting I need to change? An update I'm missing. Thanks, Marsha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 97 external data tables in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I use template wizard with data tracking in Excel 2003? | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Turning off all Automatic Formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) |