Forum Discussion
jlockley
May 20, 2026Copper Contributor
Cannot change some cells to date format in Excel
A downloaded Bank statement refuses to allow some but not all cells to be converted to date formats.
I have
- tried simply to format them as dates
- converted text to columns using both fixed width and delimiter options
- copied the text to notebook in the hope of stripping off hidden characters
- =DATEVALUE(A1) ->error
- Simply justifying the numbers right
- incantations
Any thoughts? Thank you
No RepliesBe the first to reply