Date formatting in dd/mm/yyyy

Solved/Closed
nisha - Updated on Jan 4, 2019 at 03:46 AM
 appu - Jul 23, 2013 at 07:34 AM
Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.
System Configuration: Windows XP Internet Explorer 6.0

5 replies

Hi,
  • Just use replace function under EDIT/REPLACE or press Ctrl+H.
  • Replace the . (dot) by a forward slash / .
  • Then you will be able to change the format.
  • If not, copy the result and paste it again in the column to force Excel to recalculate cells.

Good luck.
40
This worked best for me - it seems like a regular issue!
0
This worked great ! Thank you so much !
0
gud solution
0