Find a bug in Microsoft Excel

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Find a bug in Microsoft Excel

刘俊峰
A date displays 2006-6-2, but becomes 2006-6-3 when read out according to file format.

I find that Microsoft Excel counts the days of year 1900 as 366.

How to know whether the value of a RK cell is a date?

Regards,
Liu Junfeng
[hidden email]
2006-5-29
Reply | Threaded
Open this post in threaded view
|

Re: Find a bug in Microsoft Excel

Niklas Nebel
刘俊峰 wrote:
> A date displays 2006-6-2, but becomes 2006-6-3 when read out according to file format.
>
> I find that Microsoft Excel counts the days of year 1900 as 366.

Yes, that's known and documented in Microsoft's knowledge base.

> How to know whether the value of a RK cell is a date?

From the number format.

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]