Forum Discussion
Stop Excel to interpret date string as dates in text formatted cells
I am really puzzled by the Excel behavior. I have a sheet and I have a column that has format TEXT, so I expect that whatever I put there is interpreted as a string and no attempt is made to guess an...
Right Click, click the button to match destination formatting (circled red)
Wyn
MVP
Australia UTC+ 8
If this answer was the best response please click the button
I also happily accept likes