Anonymous
Not applicable

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.