general date to date format
Select the cells or entire column. Right click, select Format Cells ,In the
Category select Custom. Under Type type in mm/dd/yy or mm/dd/yyyy
Hope this helps
"sherry" wrote:
Hi
Please help
I have tried all the formulas in the other post but none work. I either get
a circular error or shows #ref or #format.
My dates look like 03-JAN-98
I need them to be date format like 01/03/98 or 01/03/1998.
I will be importing into vfp8 and need it to be in date format.
Thanks
Sherry
|