Formatting the Today() function

[test]

I am using this fucntion below:
="Form_v1 "&TODAY()

The date is represented as a 5 digit number, the result is:

Form_v1 40430

Is there a way to get the current date instead of the 5 digit number

Thanks!

 

[joeu2004]

I am using this fucntion below:
="Form_v1 "&TODAY()
The date is represented as a 5 digit number, the result is:
Form_v1 40430
Is there a way to get the current date instead of the 5 digit number

For example:

="Form_v1 " & TEXT(TODAY(),"dd mmm yyyy")

Choose the date format that you want.

PS: For broader participation, you might want to post future
inquiries using the MS Answers Forums at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum. It's just that MS has ceased to
support the Usenet newsgroups. Hence, participation here is limited
to the sites that share a common newsgroup mirror, which is no longer
centralized at MS.

 

[The_Giant_Rat_of_Sumatra]

I am using this fucntion below:
="Form_v1 "&TODAY()

The date is represented as a 5 digit number, the result is:

Form_v1 40430

Is there a way to get the current date instead of the 5 digit number

Thanks!

Format the cell as DATE and choose what portion of the string you want
to see (or use 'custom' and define it there)

 

[David Biddulph]

No. The cell contains text, so formatting as date won't work.

Joeu's answer of ="Form_v1 " & TEXT(TODAY(),"dd mmm yyyy") is the easiest
way, or you could change the formula to =TODAY() and use custom format,
something like
"Form_v1 "dd mmm yyyy

 

[AM]

No. The cell contains text, so formatting as date won't work.

Joeu's answer of ="Form_v1 " & TEXT(TODAY(),"dd mmm yyyy") is the easiest
way, or you could change the formula to =TODAY() and use custom format,
something like
"Form_v1 "dd mmm yyyy

The five digit date coded number IS a date if you piped it into a text
cell, it needs to be converted back into a date before cell formatting
will handle it as such.

 

[alanglloyd]

I am using this fucntion below:
="Form_v1 "&TODAY()

The date is represented as a 5 digit number, the result is:

Form_v1 40430

Is there a way to get the current date instead of the 5 digit number

Enter =Today() in the cell, and custom format the cell as
"Form_v1 "dd mmm yyyy

That's the easy way to combine constant text & formatted numbers.

Alan Lloyd