Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default I'm using the =today() function but I'm getting #####

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

"Diefer87" wrote in message
...
##### is what it puts in the cell, anyone know why?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Today() & Now() function Luke Excel Worksheet Functions 2 August 2nd 06 06:59 PM
Can you do a function like =TODAY() PLUS 1? Donnie Excel Worksheet Functions 6 August 9th 05 12:07 PM
TODAY function? strazz Excel Worksheet Functions 3 February 19th 05 05:57 PM
Could anyone help me with (Today function), please? azik New Users to Excel 5 December 30th 04 02:09 PM
TODAY Function Chip1035 Excel Worksheet Functions 1 December 16th 04 08:17 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"