|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 16th, 2009, 02:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today() function
I hope you guys can help me. I have used the Today() function many times, but
now, I am at a new company and the Today() function only displays ###### The fx screen shows the function als "Volatile" and will also not display the proper current date.... is there a setting I am missing? What is going on here? 
|
|
#2
April 16th, 2009, 02:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today() function
=TODAY() will display #### if the column is not wide enough.
-- Gary''s Student - gsnu200846 "Steve" wrote: I hope you guys can help me. I have used the Today() function many times, but now, I am at a new company and the Today() function only displays ###### The fx screen shows the function als "Volatile" and will also not display the proper current date.... is there a setting I am missing? What is going on here?
|
|
#3
April 16th, 2009, 02:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today() function
The today() function is always volatile because it is always open to change.
Simply widen your column to make the ### disappear. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I hope you guys can help me. I have used the Today() function many times, but now, I am at a new company and the Today() function only displays ###### The fx screen shows the function als "Volatile" and will also not display the proper current date.... is there a setting I am missing? What is going on here?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
