Anonymous
Not applicable
October 03, 2019
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
hi @DElbe ,
In Excel, if you want to convert date to text with yyyymmdd format, you can use this formula:
1. Select a blank cell next to your date, for instance. A1 is your original date, B1 is your converted date
2. Type this formula in B1 =TEXT(A1; "yyyymmdd"), and press Enter key.
3. Drag AutoFill handle over the cells needed this formula.
Hope it helps.