Date formatting

D

Db1712

I need some help with the following: I have inserted a Calendar Contro
9.0 inot my spread sheet and linked it to a cell. My problem is that
want the date selected within the calender to return a date formatte
as Monday, October 31, 2004. The linked cell is formatted correctly
however when selecting dates within the calender, it will only retur
dates formatted as 10-31-2004
 
T

tjtjjtjt

Sounds like it's coming in as text, not as a date. There are likely other
workarounds, but one option would be this:
Link the Control to a different cell.

In the cell you want the date to appear, apply the appropriate formatting and
Use the Function =VALUE(CellWithDate)

tj
 
Top