I have a CSV file with a date field. I've opened it in Excel 2011 for Macintosh.
I have
A1:Name B1: Amount C1: Date (formatted to look like 5/19/2011)
I want to refer those cells with some concatenation.
G1: ="DATE"&C1 results in:
DATE40682 (the date's serial number)
Is there a way to format it so that it looks like this:
DATE5/19/2011
So if C2 is 4/1/2011, field G2 would be DATE4/1/2011, etc...
I have
A1:Name B1: Amount C1: Date (formatted to look like 5/19/2011)
I want to refer those cells with some concatenation.
G1: ="DATE"&C1 results in:
DATE40682 (the date's serial number)
Is there a way to format it so that it looks like this:
DATE5/19/2011
So if C2 is 4/1/2011, field G2 would be DATE4/1/2011, etc...
