Microsoft Office Forums - View Single Post - Excel VBA function range.replace

Thread: Excel VBA function range.replace

View Single Post

Old

03-22-2019, 03:21 AM

thomas47

thomas47 is offline

thomas47 uses Windows 7 64bit

Windows 7 64bit thomas47 uses Office 2010 64bit

thomas47 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Mar 2014

Location: France

Posts: 6

thomas47 is on a distinguished road

Default

Thank you Debaser.
Yesterday it was working perfectly but now it doesn't work anymore.
to explain a little bit more, I replace "-" by "." to converter after cells as date.
If I keep the text "07-Jan-2019 15:36" Excel is not able to modify as "07 JAN 2019".

Reply With Quote