RE: How to stop Excel deleting leading zeros(SSRS -> Excel load)

SSC Guru

Points: 323504

March 5, 2013 at 2:41 pm

excel automatically treats anything that looks like a number as a number, dates as dates, etc

I believe you'd have to change you report of the data to explicitly place a single quote in the field, which is how Excel knows to override the behavior and treat the value as text...

that's annoying, because you have to do something like this:

SELECT

'''' + TheCode As TheCode,

'''' + '00123' As TheValue,

'''' + CONVERT(VARCHAR,321312321303) As TheDecimal

FROM YourTable

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!