So here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab/worksheet within the same workbook,in a formula it comes out formatted as a general format that doesn't look like a date at all. I have the date formatted in mm/dd/yyyy but when I try to recall that date on the following worksheet, it comes out as general. Does anybody know of any function I can use to make it come back out in the original format or am I going to have to figure out some ghetto way that will require multiple steps?? I would appreciate any help.
Thanks
Configuration: Windows XP Firefox 3.5.3