Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

I'm using the =today() function but I'm getting #####

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diefer87 - 18 Mar 2008 20:26 GMT
##### is what it puts in the cell, anyone know why?
Beege - 18 Mar 2008 20:26 GMT
> ##### is what it puts in the cell, anyone know why?

Make the cell wider?

Beege
Dave Peterson - 18 Mar 2008 20:30 GMT
Widen the column.
Change the font to something smaller.
Change the number format so that the formatted date is fewer characters.

> ##### is what it puts in the cell, anyone know why?

Signature

Dave Peterson

Tyro - 18 Mar 2008 20:49 GMT
The #'s indicate that the cell (column) is not wide enough to show the
answer or that there is an invalid date in the cell. You can widen the
column by clicking on the dividing bar to the right of the column header and
dragging until the #'s change. The cursor will change to a bar with a left
pointing and a right pointing arrow when it is on the dividing bar between
the column headers. If the #'s remain, it means the cell has an invalid
date.

Tyro

> ##### is what it puts in the cell, anyone know why?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.