| View previous topic :: View next topic |
| Author |
Message |
noalani
Newbie
Joined: 24 May 2009
Posts: 2
|
 Posted: Sun May 24, 2009 10:11 am Post subject: =NOW() function not working... |
 |
|
| when i use =NOW() the date doesnt show up on in cell. the only thing that shows up is ###. does anyone know what i am doing wrong? |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Sun May 24, 2009 10:45 am Post subject: |
|
|
| Increase the horizontal size of the cell. ### means the cell can't display the number in it. |
|
| Back to top |
|
|
noalani
Newbie
Joined: 24 May 2009
Posts: 2
|
| Posted: Sun May 24, 2009 11:04 am Post subject: |
|
|
| thank you. i feel like a dum dum now... |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun May 24, 2009 1:00 pm Post subject: |
|
|
| noalani wrote: | | thank you. i feel like a dum dum now... |
Good. Then we are not alone. 
David. |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Sun May 24, 2009 1:06 pm Post subject: |
|
|
| You mention needing the date. If that's all you need, using the TODAY() function may be better (for matching date when searching/comparing). If you need to mark time of day too, continue using NOW(). |
|
| Back to top |
|
|
|
