Jess,

Format the cell for general to show 200.

18/07/1900 is the 200nd day of Excel's date system, where each day since Dec
31, 1899 counts as 1. (That is why today is 39781.) When you entered your
formual, Excel saw that you had a date function, and automatically formatted
the
cell as a date.

For any number, use a formula like

=NumberDesired +TODAY()-39781

So, to get 751 today, and 752 tomorrow, use

=751+TODAY()-39781

HTH,
Bernie,
MS Excel MVP




"Jess" wrote in message
...
I also did your example, and all the shows up on my spreadsheet is:
18/07/1900
what does this mean?



"Shane Devenshire" wrote:

Hi,

For one cell this seems reasonable, but for an entire spreadsheet?

1. Say it was one cell, A1, and the current value as of today is 200
replace the value 200 with the formula
=200+TODAY()-39781

Starting tomorrow this cell will increase by 1 each day.

Its only going to be automatic if you use a formula or write code.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Jess" wrote:

Hello, I am just wondering if it is possible to make it so that the
numbers
in my spreadsheet increase by 1 everyday, without me having to go in
and
manually change them everyday, as this is tedious.
Any Help Here?

(I am not sure which version it is, but its either 2007 or 2008)