Dave,
Thank you so much. I know in Access it's Format(sheet2!a1,"mm/dd/yyyy") but
that didn't exist in Excel and help wasn't much help.
CLM
"Dave Peterson" wrote:
="this is the due date: " & text(sheet2!a1,"mm/dd/yyyy")
CLM wrote:
I have some notations in a cell and then I have added a link to another
spreadsheets' field that is a date. When I look at the information the date
is given in Julian format. How do I get it to be in mm/dd/yyyy format?
Excel 2000.
Thx,
CLM
--
Dave Peterson
|