Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing contents of cell based on Cell Format
I have cells with individual dates-
Current contents Desired Contents 06/01/2009 June 06/14/2009 June 07/04/2009 July 07/31/2009 July I know I can change the appearance to what I want using FORMAT CELL, but I need to change the actual cell contents to the month rather than the individual date. I used to do this using the TEXT to COLUMNS function, but it's not working like it used to in my previous version. Is there another way to do this? Thanks, Heather |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing contents of cell based on Cell Format
It's the Text function you want (not Text-to-Columns). Use;
=Text(a1,"mmmm") Regards, Fred "HeatherJ" wrote in message ... I have cells with individual dates- Current contents Desired Contents 06/01/2009 June 06/14/2009 June 07/04/2009 July 07/31/2009 July I know I can change the appearance to what I want using FORMAT CELL, but I need to change the actual cell contents to the month rather than the individual date. I used to do this using the TEXT to COLUMNS function, but it's not working like it used to in my previous version. Is there another way to do this? Thanks, Heather |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing contents of cell based on Cell Format
Fantastic, thank you!
"Fred Smith" wrote: It's the Text function you want (not Text-to-Columns). Use; =Text(a1,"mmmm") Regards, Fred "HeatherJ" wrote in message ... I have cells with individual dates- Current contents Desired Contents 06/01/2009 June 06/14/2009 June 07/04/2009 July 07/31/2009 July I know I can change the appearance to what I want using FORMAT CELL, but I need to change the actual cell contents to the month rather than the individual date. I used to do this using the TEXT to COLUMNS function, but it's not working like it used to in my previous version. Is there another way to do this? Thanks, Heather . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing contents of cell based on Cell Format
You're welcome. Thanks for the feedback.
Fred. "HeatherJ" wrote in message ... Fantastic, thank you! "Fred Smith" wrote: It's the Text function you want (not Text-to-Columns). Use; =Text(a1,"mmmm") Regards, Fred "HeatherJ" wrote in message ... I have cells with individual dates- Current contents Desired Contents 06/01/2009 June 06/14/2009 June 07/04/2009 July 07/31/2009 July I know I can change the appearance to what I want using FORMAT CELL, but I need to change the actual cell contents to the month rather than the individual date. I used to do this using the TEXT to COLUMNS function, but it's not working like it used to in my previous version. Is there another way to do this? Thanks, Heather . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing cell contents based on a condition | New Users to Excel | |||
How do I format a cell based on the contents of a different cell? | Excel Worksheet Functions | |||
How do I format a cell based on the contents of a different cell? | Excel Discussion (Misc queries) | |||
How do I format one cell based on contents in another cell in Exce | Excel Discussion (Misc queries) | |||
Can I format a row based on the contents of one cell? | Excel Discussion (Misc queries) |