Data Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert date to serial number 12
Convert a range of numbers to strings 2
End of Quarter Based on Fiscal Year 2
VB converting UK to US dates, randomly, ignores cdate func! 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Using Crosstab column headings for conditional formatting in report 0
Active XText box vbcr shows symbol instead of an actual carraige return 2
Inserting colon as text 4

Back
Top