asked on

SQL report when copied into Excel looses format

Here is a sample of a column in my report in SQL. The patient's account number is a randomly generated number in the system:

SQL
ACCOUNT#
0010
001000
0015
001500
0020
002000
1000
1050
1100
1200

When I paste this in Excel the column converts to GENERAL and the number looks like this:

10
1000
15
1500
20
2000
1000
1050
1100
1200

I want to export as a CVS file type so I do I keep the original number that was used in the SQL report .

KR

SOLUTION

Brian Crowe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kvrogers

ASKER

I will try this in the morning as I am getting ready to leave work. Will let you know then if the formatting before I copy the text works.

I did try selecting the column and changing it to TEXT after I pasted it in and all it did was move the numbers over to the far right. It did not change the numbers at all. So the first number remained 10 instead of 0010.

KR

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.