MrExcel Publishing
Your One Stop for Excel Tips & Solutions

changing data to text?


Posted by Zac on January 07, 2002 6:54 AM

Thanks for the help with the save_as macro guys!

I enter a date as 1/7/02, which is displayed at January 7,2002. When the macro pulls the date out, if gets 1/7/02, which of course, can't be used as a directory(don't want it like that, I just need January. I tried making a custom cell that would just display the month from the other cell's entire date, but it will pull the entire data as 1/7/02.

Thanks for any help!


Posted by Aladin Akyurek on January 07, 2002 7:23 AM

You could use:

=TEXT(A1,"MMMM")

where A1 houses a date.

Aladin

=========