Formula
If you want to do it in place, use Format/Cells/Number/Date and choose
your preferred format.
If you want the result in a different cell:
B1: =A1
Format B1 as mm/dd/yyyy
In article ,
CP wrote:
Hi: Is there a simple formula to change a date in a field from one format to
another, for example 24-Dec-2007 to read 12/24/2007? Thanks.
|