Excel Date formatting problem [Solved/Closed]

Report
Posts
2
Registration date
Sunday September 20, 2009
Status
Member
Last seen
September 22, 2009
-
Posts
2
Registration date
Sunday September 20, 2009
Status
Member
Last seen
September 22, 2009
-
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

2 replies

Just format the cells containing the formula in the date format.
Posts
2
Registration date
Sunday September 20, 2009
Status
Member
Last seen
September 22, 2009

You can't do it when the link to the cell is imbedded within a formula. For example, when you type this for a formula in a cell

="11-05100-0"&B3

where the cell B3 equals 8/31/09

it comes out looking like

11-05100-040056

when I need it to look like

11-05100-08312009

Anybody have any ideas?