Excel 2002 Date Formatting

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

Guest

Assuming the date entered is "01.27.2005", I want to format as "JAN.2005"
(not "Jan.2005") - is this possible?
 
Can you use a helper cell and show the results there?

=UPPER(TEXT(DATEVALUE(SUBSTITUTE(A1,".","/")),"mmm.yyyy"))

Worked ok with my USA date settings (mdy).

substitute() changed the dots to slashes.
datevalue() made it a real date
text() changed it to Jan.2005
and upper() changed the case.
 
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

Why this paste result? 4
Text to dates 6
Access Count dates within a Month 4
Excel Help with dates 2
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES 3
repeated conversion of data summarized into rows and columns 4
Converting date format 4
Formula using formatted dates 5

Back
Top