Format Date In A Column To mm/dd/yyyy

**jadepu2010** · 11-02-2020, 12:13 PM

Hi

I have a column with all dates formatted as "2018-November-12" , I want to change the format to "11/12/2018".
I have tried to use Sheet.Range("M:M").NumberFormat = "mm/dd/yyyy", but it's not working for me.

Please help.

**BMV** · 11-02-2020, 12:31 PM

"2018-November-12" - is probably text and must be converted but not by format. You can use CDate or Copy/pastspecial or ...

Format Date In A Column To mm/dd/yyyy

LinkBack

Thread Tools

Rate This Thread

Display

Format Date In A Column To mm/dd/yyyy

Re: Format Date In A Column To mm/dd/yyyy

Thread Information

Users Browsing this Thread

Similar Threads

Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

[SOLVED] Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

Convert Date format from Text format reading m/d/yyyy to dd/mm/yyyy

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

Column Range with date Format MM/DD/YYYY independate of sys date Format

opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions