Formatting with CONCATENATE

B

Brian

I would like to use the TODAY() function with a leading word, in this case
"Per ". The formula

="Per "&TODAY() produces "Per 38238" and I can't see any way to format the
"38238" to make today's date readable. It's easy to do it by using 2
columns, one for "Per" and one for the date, but is there any way to do this
in one column?
 
K

Kevin H. Stecyk

Brian wrote...
I would like to use the TODAY() function with a leading word, in this case
"Per ". The formula

="Per "&TODAY() produces "Per 38238" and I can't see any way to format the
"38238" to make today's date readable. It's easy to do it by using 2
columns, one for "Per" and one for the date, but is there any way to do
this
in one column?
Click to expand...
Hi Brian,

One way...

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

Hope this helps.

Regards,
Kevin
 
N

Norman Jones

Hi Brian,

Try:

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

Amend the format to taste.
 
D

Dave Peterson

One more method is to format the cell itself--this has the added benefit of
keeping the value a date (that you can use in later calculations????)

Format|Cells|number tab|custom
"Per "mm/dd/yyyy
 
Top