EASY: Format NOW as mm/dd/yyyy

  • Thread starter Thread starter pauloreiss
  • Start date Start date
P

pauloreiss

I have this simple function:

="Sales of: " & NOW()

But this way the date is appears with that Excel code like
33046,30184. I wanted to show 04/28/2006.
What is the function to set a format for the variable?

Something like =formatdate(now();mm/dd/yyyy)

Thanks!
 
Actually, you're pretty close....try this:

="Sales of: " & TEXT(TODAY(),"MM/DD/YYYY")

Does that help?

Regards,
Ron
 

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

Excel is seeing the date as dd/mm/yyyy 4
SAVE AS CSV, KEEP DATE FORMAT 2
Converting mm/dd/yyyy to yyyy/mm/dd 6
converting dd/mm/yy to mm/dd/yyyy 3
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
convert date 1
Forcing a date entry format of dd/mm/yyyy 1
How to Convert 24/03/2010 as text into 03/24/2010 date format 2

Back
Top