kvrogers
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
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