0

For Excel associated with Microsoft Office 2016: I have seen answers to keeping leading zeros in Excel for a number, but how does one keep the leading zeros displayed for a text string (taken from a TSQL-varchar): e.g. 000A0 ?

Improve this question

1 Answer 1

Reset to default
3

Append an ' (apostrophe) character in front of the string to force Excel to treat it as a string.

You might also have luck if you preformat your cell as text.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .