Date problem

[Itachi1]

Hello,

i am currently entering some cheque details by month.

First thing i need to enter is the date and i hate having to retype 24/11/2011 for every cheque. Can i set the Month & Year as a format please?

I mean can i input 24 and hit enter/tab and have 24/11/2011 in my cell?

I am using MS Excel 2010

Thanks a lot

[royUK]

What happens when the month changes?

[Itachi1]

Ill just modify the macro and make November to December no?

[arthurbr]

Ctrl + ; will enter todya's date

[Itachi1]

Ctrl + ; will enter todya's date

Sorry Sir, i dont think you understood.

I have like 200 cheques which are dated from 1-30 Novemer.

So one cheque is 15/11/2011
The other is 21/11/2011
The other is 03/11/2011

Is there a way where can i enter 15 and the date gets 15/11/2011 all i want is to set 11/2011 as final like a format in itself.

Thanks

[brokenbiscuits]

You could use a custom format of 0"/11/2011"

[Itachi1]

Thanks approved reputation

[Itachi1]

Im new to forum how shoul i put this thread to solved?

[arthurbr]

Don't think adding a format will be of any use for eventual analysis needed later

[Itachi1]

Yes but in my case its more that enough sir,

Thanks for your help

[tom1977]

try this

Please Login or Register  to view this content.

it works in column A
probably you would have to change "-" into "/" but check this first