G
Guest
I want to enter a date in text as in:
January 25, 2001
And then i want Excel to display it as:
1/25/01.
When i tryed to format the cells the date is displayed as I have typed it in.
Can anyone help me do this?
January 25, 2001
And then i want Excel to display it as:
1/25/01.
When i tryed to format the cells the date is displayed as I have typed it in.
Can anyone help me do this?