date should be as 01/Jan/2012 if I enter like 01012012

January 3, 2012 at 23:42:46
Specs: Windows XP
hi I want the date as 01/Jan/2012 in cell where I want to

See More: date should be as 01/Jan/2012 if I enter like 01012012

Report •


#1
January 4, 2012 at 06:05:02
Change date format in Control Panel > Regional Settings (I don't use XP anymore so I'm guessing that's where you change it).

Report •
Related Solutions


Ask Question