Reputation: 1623

Excel automatically converts to date?

I have an excel file that always converts k 6-8 to a date. Is there anyway to not make this happen? I have tried making a plain text field to prevent this and still no luck. Any ideas?

Upvotes: 0

Answers (3)

user2211940

Reputation: 1

Try putting an space before the 6-8 to force it to text.("6-8" as " 6-8" --- notice space)

Upvotes: 0

theproxy

Reputation: 31

Try putting an apostrophe (') before the 6-8 to force it to text.

Upvotes: 0

SQLMenace

Reputation: 134923

put a tick in front of it so instead of k 6-8 do 'k 6-8

Upvotes: 1

Excel automatically converts to date?

Answers (3)

Related Questions