Problems copying and pasting decimal fields

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
 
B

bosco

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.
 
M

Marcin

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

==========================================================================
 
A

aaron.kempf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Populating a Text Field with a value in an Excel Sheet 0
Copy and Paste Special in Excel #REF error 1
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Fixed Decimals in Excel 2007 4
ACCESS TO EXCEL 1
pasting time from html 12
Decimal Alias values return as zero? 5

Top