Problems copying and pasting decimal fields

  • Thread starter Thread starter bosco
  • Start date Start date
B

bosco

I have a problem copying or exporting from the adp to excel for any
field/attribute formatted as decimal. When I paste or export into
Excel, excel thinks that it is a text field, and I have to convert to
number every time. However, if I load the same query in SQL Query
Manager, and copy and paste from it, Excel recognizes it as a number.
I know that for Office XP there was a patch for a similar problem
(q328933), but I don't see a patch for this in Office 2003. Any
thoughts?

thanks,

Jason Bostelman
 
Hmm. A convert(money) fixed the problem. However, it's weird because
I only have the problem when there was a case statement. Regular
select statements had no problem.
 
Uzytkownik said:
I have a problem copying or exporting from the adp to excel for any
field/attribute formatted as decimal. When I paste or export into
Excel, excel thinks that it is a text field, and I have to convert to
number every time. However, if I load the same query in SQL Query
Manager, and copy and paste from it, Excel recognizes it as a number.
I know that for Office XP there was a patch for a similar problem
(q328933), but I don't see a patch for this in Office 2003. Any
thoughts?

thanks,

Jason Bostelman
Click to expand...
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================
 
wow never knew about that one

this was one of my chief complaints about excel though

it's an excel problem not an access problem
 
Back
Top