S
Spartacus
In a workbook excel 97 forces calculation when I put in a cell
04/04/2004, ie. excel calculates =4/4/2004. The cell's has date format
then the result is jan-01-1900, because it calutaes the quotient 1/200
!!! . Do not matter why I do to resolve the trouble still the same. I
I put vgr. 04-04-2004, excel reedit the content in the formula ba
adding a "=" sign at the string begin changing to =4-4-2004 result
error ###### in date format, of course,but -2004.00 in general format
The most curious is if i insert a new sheet in this worbook exc
manages well the date and hour input. No macros is running or any addi
in the worbook, i take a copy of the file and open in another machin
and problem is the same. Is it a bug before reported? Could I fix th
problem?
Thank You!
:confused
04/04/2004, ie. excel calculates =4/4/2004. The cell's has date format
then the result is jan-01-1900, because it calutaes the quotient 1/200
!!! . Do not matter why I do to resolve the trouble still the same. I
I put vgr. 04-04-2004, excel reedit the content in the formula ba
adding a "=" sign at the string begin changing to =4-4-2004 result
error ###### in date format, of course,but -2004.00 in general format
The most curious is if i insert a new sheet in this worbook exc
manages well the date and hour input. No macros is running or any addi
in the worbook, i take a copy of the file and open in another machin
and problem is the same. Is it a bug before reported? Could I fix th
problem?
Thank You!
:confused