- yourhuntingappAsked on July 20, 2016 at 10:09 PM
- JotForm SupportliyamAnswered on July 20, 2016 at 11:19 PM
You can format a date on how you think it is convenient for you. Do you have a specific concern or purpose for this?
Looking forward to your response.
- yourhuntingappAnswered on July 21, 2016 at 10:45 AMI am importing my data from an excel file. I have modified the cell format to be a date and when I import the data it just shows up as numbers. It does not keep the date format.
- JotForm SupportKevin_GAnswered on July 21, 2016 at 12:13 PM
You should right click on the cell you want to format then click on the option "Format Cells", you should get a window like the one below, there you should select "Text" and click OK:
Then in your Excel file you should add the date with these two different formats:
This should be the result:
Hope this helps.