Persistent problem with date formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Persistent problem with date formatting

FAQ

Thread Tools

Display Modes

06-18-2021, 12:45 PM

Purfleet

Windows 10 Persistent problem with date formatting

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

Column A is text with non printable characters and spaces, then it is also in US format (maybe a setting in Excel or your bank).

I would add another column with the below formula

=MID(TRIM(CLEAN(A2)),4,2)&"/"&MID(TRIM(CLEAN(A2)),1,2)&"/"&MID(TRIM(CLEAN(A2)),7,4)

then in the next column add zero to make it a number

Probably can be done in Power Query but i have hardly ever used PQ

Attached Files

Abbreviated Excel spreadsheet_ar12.xlsx (17.5 KB, 8 views)

Tags

date format problem

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A persistent line of small square dots	johngross	Word	4	02-23-2020 02:59 PM
MM persistent request for seperators	JLOB	Mail Merge	5	01-30-2020 02:50 PM
Date-formatting problem	Ulodesk	Excel	6	06-08-2014 02:27 PM
Review > Markup. Deselect "Formatting" is not persistent	OldGrantonian	Word	3	02-06-2014 03:30 AM
Date formatting	kjxavier	Excel	0	08-10-2011 08:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 AM.