Excel Date formatting problem

Solved/Closed
chow70 Posts 2 Registration date Sunday September 20, 2009 Status Member Last seen September 22, 2009 - Sep 21, 2009 at 01:52 PM
chow70 Posts 2 Registration date Sunday September 20, 2009 Status Member Last seen September 22, 2009 - Sep 22, 2009 at 10:19 AM
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
Related:

2 responses

Just format the cells containing the formula in the date format.
0
chow70 Posts 2 Registration date Sunday September 20, 2009 Status Member Last seen September 22, 2009
Sep 22, 2009 at 10:19 AM
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?
0