Formatting today()
 

I want to generate the text: "Printed on mm/dd/yy." where "mm/dd/yy"
is replaced by the value from today().

If I put "today()" in a cell by itself, it displays as 12/24/06.

But if I enter this code:

=CONCATENATE("Printed on ",TODAY())

it displays as: "Printed on 39075.".

The only solution I could come up with is:

=CONCATENATE("Printed on
",MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY()),".")

which is ugly.

Is there no "format" function that would allow me to write something
like this:

=CONCATENATE("Printed on ",FORMAT(TODAY(),"U"))

where the "U" is short for USA format (mm/dd/yy)?

Ideally, the Today function would have accepted a format parameter,
like =today("U").

--
Running Excel 2000 SP-3 on Windows 2000

Formatting today()
 

Why not have this as a Header/Footer.
File Page setup Header/Footer Custom Footer
Type: "Printed on" (no quotes) then click the calendar icon.
This should become: Printed on & [Date]
Format as required.

George Gee


"LurfysMa" wrote in message
...
I want to generate the text: "Printed on mm/dd/yy." where "mm/dd/yy"
is replaced by the value from today().

If I put "today()" in a cell by itself, it displays as 12/24/06.

But if I enter this code:

=CONCATENATE("Printed on ",TODAY())

it displays as: "Printed on 39075.".

The only solution I could come up with is:

=CONCATENATE("Printed on
",MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY()),".")

which is ugly.

Is there no "format" function that would allow me to write something
like this:

=CONCATENATE("Printed on ",FORMAT(TODAY(),"U"))

where the "U" is short for USA format (mm/dd/yy)?

Ideally, the Today function would have accepted a format parameter,
like =today("U").

--
Running Excel 2000 SP-3 on Windows 2000

Formatting today()
 

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

--
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
...
I want to generate the text: "Printed on mm/dd/yy." where "mm/dd/yy"
is replaced by the value from today().

If I put "today()" in a cell by itself, it displays as 12/24/06.

But if I enter this code:

=CONCATENATE("Printed on ",TODAY())

it displays as: "Printed on 39075.".

The only solution I could come up with is:

=CONCATENATE("Printed on
",MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY()),".")

which is ugly.

Is there no "format" function that would allow me to write something
like this:

=CONCATENATE("Printed on ",FORMAT(TODAY(),"U"))

where the "U" is short for USA format (mm/dd/yy)?

Ideally, the Today function would have accepted a format parameter,
like =today("U").

--
Running Excel 2000 SP-3 on Windows 2000

Formatting today()
 

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

Formatting today()
 

On Sun, 24 Dec 2006 16:48:46 -0000, "George Gee"
wrote:

Why not have this as a Header/Footer.
File Page setup Header/Footer Custom Footer
Type: "Printed on" (no quotes) then click the calendar icon.
This should become: Printed on & [Date]
Format as required.

Thanks. That would work, but I don't want it in the footer.

--
Running Excel 2000 SP-3 on Windows 2000

Formatting today()
 

="Printed on " &TEXT(TODAY(),"mm/dd/yy")

Don't need to concatenate the cells.


Gord Dibben MS Excel MVP

On Sun, 24 Dec 2006 08:24:59 -0800, LurfysMa wrote:

I want to generate the text: "Printed on mm/dd/yy." where "mm/dd/yy"
is replaced by the value from today().

If I put "today()" in a cell by itself, it displays as 12/24/06.

But if I enter this code:

=CONCATENATE("Printed on ",TODAY())

it displays as: "Printed on 39075.".

The only solution I could come up with is:

=CONCATENATE("Printed on
",MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY()),".")

which is ugly.

Is there no "format" function that would allow me to write something
like this:

=CONCATENATE("Printed on ",FORMAT(TODAY(),"U"))

where the "U" is short for USA format (mm/dd/yy)?

Ideally, the Today function would have accepted a format parameter,
like =today("U").

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

Formatting today()
 

your cell " =today()
go to formatcellnumbercustom
type "Printed on" mm/dd/yy

in this way, you can retain this cell for any linking purpose or a true hard
value copypasting purpose <for records of successive printing on
intermittent dates
happy holidays


"LurfysMa" wrote:

I want to generate the text: "Printed on mm/dd/yy." where "mm/dd/yy"
is replaced by the value from today().

If I put "today()" in a cell by itself, it displays as 12/24/06.

But if I enter this code:

=CONCATENATE("Printed on ",TODAY())

it displays as: "Printed on 39075.".

The only solution I could come up with is:

=CONCATENATE("Printed on
",MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY()),".")

which is ugly.

Is there no "format" function that would allow me to write something
like this:

=CONCATENATE("Printed on ",FORMAT(TODAY(),"U"))

where the "U" is short for USA format (mm/dd/yy)?

Ideally, the Today function would have accepted a format parameter,
like =today("U").

--
Running Excel 2000 SP-3 on Windows 2000