View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default Formatting today()

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"LurfysMa" wrote in message
...
On Sun, 24 Dec 2006 11:54:11 -0500, "Paul B"
wrote:

LurfysMa, something like this
="Printed on: " & TEXT(TODAY(), "MM/DD/YY")


Perfect. The Text() function is what I was looking for. Thanks very
much.

I guess it would be too much trouble to have that show up in the help
search results for "format".


--
Running Excel 2000 SP-3 on Windows 2000