Excel formula

  • Thread starter Thread starter xrucker
  • Start date Start date
X

xrucker

Two problems have developed in only one worksheet file. I
can not format the date column. no matter what I chose
for date entering always comes up 1/1/00 second problem
has just occored dragging the balance on a check book
file has worked until now all I get is Value ?? small
help icon says error in formula but this formula has been
working and continue dragging to cells for about 350
cells is there a limit to cells that you can drag a
formula?
 
-----Original Message-----corrected email address
Two problems have developed in only one worksheet file. I
can not format the date column. no matter what I chose
for date entering always comes up 1/1/00 second problem
has just occored dragging the balance on a check book
file has worked until now all I get is Value ?? small
help icon says error in formula but this formula has been
working and continue dragging to cells for about 350
cells is there a limit to cells that you can drag a
formula?
.
Click to expand...
 
Hi

for your second problem: Please post your formula so that we can have a
look at it. There is no limit for dragging formulas.

Frank
 
For your first problem 1/1/00 is probably Jan 1, 1900 which has a date
serial of 1. Do you have values in the cell between .5 and 1.5? This could
happen if a time was entered, rather than a date.

Format the cell as a number, or as General, so you can see better what's in
the cell.
 
Back
Top