G Guest Jan 19, 2004 #1 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?
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?
P Paul Jan 19, 2004 #2 Ron Cardy said: I have a column of dates in the format xx.yy.zzzz. I want them to be Click to expand... 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.
Ron Cardy said: I have a column of dates in the format xx.yy.zzzz. I want them to be Click to expand... 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.
