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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I convert 02/05/05 to 02, please? (https://www.excelbanter.com/excel-worksheet-functions/20298-how-do-i-convert-02-05-05-02-please.html)

R.Culley

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

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

Niek Otten

=MONTH(A1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.Culley" wrote in message
...
Many thanks - I want to set up an accounting worksheet with a monthly
payment, any help very gratefully received.

R.Culley

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!

On Sat, 2 Apr 2005 09:47:22 +0200, "Niek Otten"
wrote:

=MONTH(A1)

All times are GMT +1. The time now is 05:40 AM.