Formula date issue

[sheldon]

Hi,

I am entering a date into a sheet via a formula within the worksheet. I have formatted the cell as Date, but when the the date is entered into the cell it changes format to text and the date is displayed as a number e.g. 360608.

Do you know how I would make the formula enter the date, in the format Date?

Thanks

[CreganTur]

Are you using a formula or VBA code?

Can you please post what you're using so we can see exactly what's going on?

For future reference, this is the Access Help forum- we're not going to drive you out with pitchforks and torches or anything:bat2: - there's a lot of overlap here so we're more than happy to help. Just bear that in mind for the future.

[sheldon]

Sorry mate, wasn't paying attention when I clicked the link. Ment to post in Excel.

Thanks