Microsoft Office Forums - View Single Post - Today()

Thread: Today()

View Single Post

Old

12-08-2010, 12:00 AM

coolpeter86 coolpeter86 is offline

coolpeter86 is offline

coolpeter86 uses Windows 7

Windows 7

coolpeter86 uses Office 2007

Office 2007

Novice

The original poster

Join Date: Dec 2010

Location: India

Posts: 5

coolpeter86 is on a distinguished road

Default

Today()

Can I use Today() function in between a string using &-s in between and get the right date format?

="Todays date is"&TODAY()
this is returning
Todays date is 40520

But I need like this.

Todays date is 12/08/2010

Reply With Quote