| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2P import
I am trying to import a report from an accounting software to Excel 2003 and
the field is 2P in SQL but when it gets to Excel it has the value of ..5833333+. I have other data that is 2Q and it gets to Excel fine. What is causing the issue with 2P and 3P? Thanks to anyone who responds! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2P import
The problem is that Excel is treating the "2 P" as 2:00:00 PM. (Times are
stored as a fraction of a 24 hours day -- 6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75 -- and 2:00:00 = 14:00:00 = 0.583....). You can try formatting the cells at Text before importing the data. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Accounting user" <Accounting wrote in message ... I am trying to import a report from an accounting software to Excel 2003 and the field is 2P in SQL but when it gets to Excel it has the value of .5833333+. I have other data that is 2Q and it gets to Excel fine. What is causing the issue with 2P and 3P? Thanks to anyone who responds! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2P import
That makes sense = Thanks
"Chip Pearson" wrote: The problem is that Excel is treating the "2 P" as 2:00:00 PM. (Times are stored as a fraction of a 24 hours day -- 6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75 -- and 2:00:00 = 14:00:00 = 0.583....). You can try formatting the cells at Text before importing the data. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Accounting user" <Accounting wrote in message ... I am trying to import a report from an accounting software to Excel 2003 and the field is 2P in SQL but when it gets to Excel it has the value of .5833333+. I have other data that is 2Q and it gets to Excel fine. What is causing the issue with 2P and 3P? Thanks to anyone who responds! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| XML Import | Excel Worksheet Functions | |||
| Import from web. | Excel Discussion (Misc queries) | |||
| Import xml | Excel Worksheet Functions | |||
| import | Excel Discussion (Misc queries) | |||
Hybrid Mode
