date conversion

  • Thread starter Thread starter ranvin56
  • Start date Start date
R

ranvin56

I have a spreadsheet that once you input a date in one of the cells it
separates it in two other cells one for the month and one for the day.
However, in doing so it list the month by numbers (ex "10" for "Oct"). I want
to have the month inputed by its name. I've tried "If" statement but there's
too many levels in the function for it to work. Does anyone have any
suggestions?
 
=TEXT(A1,"mmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet that once you input a date in one of the cells it
| separates it in two other cells one for the month and one for the day.
| However, in doing so it list the month by numbers (ex "10" for "Oct"). I want
| to have the month inputed by its name. I've tried "If" statement but there's
| too many levels in the function for it to work. Does anyone have any
| suggestions?
 
You must log in or register to reply here.

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

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Day of the week and date 3
If statement with dates 0
Please help....Date Format issue 1
Expanding Date formula 1
Dates not entered correctly 6
Excel Vba to change displayed year automatically. 14
accepting most recent date across columns 10

Back
Top