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!

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!

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!