date

A

afdmello

Hi gurus

EXCEL 2007

Why does the date change from 23.03.08 to 23.03.09 when using the fill
handle from one cell to another?

Afd
 
G

Gord Dibben

What are the settings for Short Date under your Windows Regional Seetings.

That may not be a valid date and is text.

What happens when you enter a date such as 3/23/08 and copy down?


Gord Dibben MS Excel MVP
 

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

date 3
fill right 2
date calculation 9
how to date 4
Date formula 2
hyperlink 4
copy sheets for formula 1
Vlookup 8

Top