Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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"). |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |