Pretty basic question for a more advanced user than me but I can't seem to find an option.
I am working on an order form for my clients to fill out by plugging data into a preformatted spreadsheet. However, I am using a date format that apparently Excel doesn't like.
This: 01-31-15
Keeps changing to this: 1/31/2015
This just really doesn't work with what I am doing and I don't want to retype every date on every order.
I've tried making it a General text field, there are no existing functions in the cell but then it changes my setting to a date field and just keeps reformatting. I've also tried cursing at it and that didn't help either. :)
mm-dd-yy
doesn't work for you?