| Home |
| Search |
| Today's Posts |
|
#1
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Today() function | Excel Worksheet Functions | |||
| Do I use the TODAY() FUNCTION | New Users to Excel | |||
| I'm using the =today() function but I'm getting ##### | Excel Worksheet Functions | |||
| Can you do a function like =TODAY() PLUS 1? | Excel Worksheet Functions | |||
| TODAY Function | Excel Worksheet Functions | |||
Linear Mode
