Excel automatically converts to date?

Tags: excel 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?


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