Ron Cardy said:
I have a column of dates in the format xx.yy.zzzz. I want them to be
displayed as the format xx/yy/zzzz. The cell format custom option does not
convert the date from one to the other. How can I do this?
At the moment, you actually have text strings, not dates.
Select the column and use
Edit > Replace
Under "Find what:" put "." (without the quotes).
Under "Replace with:" put "/" (without the quotes).
This should convert to dates which you will then be able to format as you
wish.
