D
David Biddulph
What do you mean by "the above function did not work"?
What error message did you get? If not an error message, what value did the
formula =TEXT(DATE(2007,11,25),"mmmm dd, yyyy") return? If the cell merely
displayed the formula, rather than the result, make sure that you haven't
got the cell formatted as text; if it is, then format as General, and
either re-insert the formula, or hit F2 to get into formula edit mode and
hit Enter.
What error message did you get? If not an error message, what value did the
formula =TEXT(DATE(2007,11,25),"mmmm dd, yyyy") return? If the cell merely
displayed the formula, rather than the result, make sure that you haven't
got the cell formatted as text; if it is, then format as General, and
either re-insert the formula, or hit F2 to get into formula edit mode and
hit Enter.