Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date conversion
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date conversion
hi
how are you spliting the date? regards FSt1 "ranvin56" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date conversion
=TEXT(A1,"mmm")
-- Kind regards, Niek Otten Microsoft MVP - Excel "ranvin56" wrote in message ... |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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Date conversion | Excel Discussion (Misc queries) | |||
Date Conversion - sorry | New Users to Excel | |||
Date Conversion | Excel Worksheet Functions | |||
Date Conversion | Excel Discussion (Misc queries) |