Date formatting

  • Thread starter Thread starter Db1712
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Question 1
Excel 2007 displayed dates 2
ENTER A DATE USING CALENDAR CONTROL 2
Calendar date format 2
Stop dates from showing as numbers - when formated as dates 1
Excel Colour code dates 1
Date Format 2
Conditional Formating based on start and end dates 1

Back
Top