How do I convert 02/05/05 to 02, please?

R.Culley · Apr 2, 2005

Many thanks - I want to set up an accounting worksheet with a monthly
payment, any help very gratefully received.

Niek Otten · Apr 2, 2005

=MONTH(A1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

R.Culley · Apr 8, 2005

Very many thanks.

I am very sorry you did not get my reply, I fear. Tried to send one
by e-mail and it didn't work!