View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Writing a month name from its number

try this

="Asset based fee for "& TEXT(B2,"mmmm") &" "& TEXT(B2,"yyyy")

--


Gary

"travis" wrote in message
...
If I evaluate month(7/7/2008) I get the number 7.

Apart from a whole bunch of nested if statements or something, how
would I get "July" instead?

Is there a built in function that does that?

This is in the context of a formula:

="Asset based fee for "&MONTH(B2)&" "&YEAR(B2)

Which displays "Asset based fee for 7 2008", where I'd like it to say
"Asset based fee for July 2008".

Travis