2P import

[Accounting user]

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!

 

[Chip Pearson]

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]

That makes sense = Thanks

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)