I've got an Excel template that users enter data into. We have Customer ID's
with leading zeros, but Excel cuts them off and treats them as numeric
values. Is there any way I can define a column as text so the user can enter
0000456 without having to key a ' before the entry?

I've tried defining the column using Data = Text to Columns = Text, but
that isn't working.