Formatting with CONCATENATE

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
Hi,
Try some variation of the following:
="Per "&TEXT(TODAY(),"MM-DD-YY")
 
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
 
Hi Brian,

Try:

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

Amend the format to taste.
 
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
 
You must log in or register to reply here.

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

Filtering with SUMIFS 1
conditional formatting date and blank cell 3
vacation accrual formula 2
Conditional Formatting: 2003 to 2010 1
30 fields each to be checked by 1000 people 2
Dynamically reference a cell based on cell content 1
macro for displaying conditional formatting 1
if then and conditional formatting of dates 2

Back
Top