sql2k8 (4/22/2010)
when i use these options i get the above mentioned issue '0123 but not 0123.
Putting '0123 in Excel is the same as 0123. The ' serves as a text identifier, so that Excel knows that it is text and not a number, otherwise it would drop the leading zero.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP