Home |
Search |
Today's Posts |
#1
|
|||
|
|||
the function FORMAT()
We used to have this function in the previous MS Excel and MS Acess whereby
to format a date in a formula like ="today is:"&FORMAT(today(),"ddd/mmmm/yyyy"). apparently this function disappeared?? |
#2
|
|||
|
|||
You can have
=TEXT(today(),"ddd/mmmm/yyyy") in a worksheet, or FORMAT(Date,"ddd/mmmm/yyyy") in VBA. -- HTH RP (remove nothere from the email address if mailing direct) "Jonas" wrote in message ... We used to have this function in the previous MS Excel and MS Acess whereby to format a date in a formula like ="today is:"&FORMAT(today(),"ddd/mmmm/yyyy"). apparently this function disappeared?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date function format in footer | Excel Worksheet Functions | |||
Format Column with Same Function | Excel Worksheet Functions | |||
Problem with function format | Excel Worksheet Functions | |||
TEXT function to format a date in English & French | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |