Thread: Data Types
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Todd.Hennig[_2_] Todd.Hennig[_2_] is offline
external usenet poster
 
Posts: 1
Default Data Types

Worked perfectly, many thanks!

"Gary''s Student" wrote:

=TEXT(TODAY(),"mmmm")

will get you a real txt month
--
Gary''s Student - gsnu200750


"Todd.Hennig" wrote:

Hey,

If I have a date (stored in serial number format from the =TODAY() function)
which is being displayed as a month written out in text e.g. "October" in the
cell, how can I save the text string being displayed so that I can use it
with the VLOOKUP fuction in a list of months that are all text strings?

-Todd