S
Steven
I have a spreadsheet in which several columns are dates. However, I cannot
get Excel to use the values from those columns for computation.
The column's first cell value is shown as 6/1/2006. THe cell format is as
*3/14/2001. WHen I try to do any computations with it, including using
datevalue to try to convert it, I get a #VALUE! error message.
I tried to be sneaky and used a new column with formulas = K2+0 to try to
convert the cells. The new column computes the values fine but when will
also return #VALUE when I try to use them for computing.
get Excel to use the values from those columns for computation.
The column's first cell value is shown as 6/1/2006. THe cell format is as
*3/14/2001. WHen I try to do any computations with it, including using
datevalue to try to convert it, I get a #VALUE! error message.
I tried to be sneaky and used a new column with formulas = K2+0 to try to
convert the cells. The new column computes the values fine but when will
also return #VALUE when I try to use them for computing.