Excel automatically converts to date?

Tags: excel date
Question!

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?



Answers

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

By : theproxy


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



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

By : SQLMenace


This video can help you solving your question :)
By: admin