>I have a datetime column in Excel .The format is set to 3/14/01. The data is appearing as all ###. When I turn on Show Formulas, the date appears as 35215137166900.
>
>I'm confused. What is this???
Dates are stored, in Excel, as a serial number; fractions of a date are the decimals. The number stored is way to high for a date. For example, the today() function (I guess it would be today() - I am trying it in Spanish), when converted to a value, currently stores the value 40102.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
