date format

Giganews Newsgroups
Subject: date format
Posted by:  Gerald
Date: Fri, 19 May 2006

I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from Format>>Custom>>mm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks

Replies