Date format change
[Closed]
Report
Ane
-
rizvisa1
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Related:
- Date format change
- Whatsapp time format change - How-To - Mobile
- Mail merge date format change - How-To - Excel
- Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
- Date format change in excel ✓ - Forum - Excel
- How to change custom date format to general in excel - How-To - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
i am sure you are aware of using of formatting. So I am presuming that change of format is not making any difference. It would be due to that in excel dates are internally stored as number. So if you click on the date and then go to Data, text to columns, make sure Delimited is highlighted and press next. unselect all check box and choose date and select the format choose DMY format.
