data type inconsistency

[flyfisher]

Hi,
i have a rather large spreadsheet (>21k records) and i appended some
new records on to the bottom from a text file. i have since formatted
the cells so that they are all dates. when i do a =weeknum calc on the
new dates, i get "#VALUE". the error message tells me that the input is
the wrong data type. if i go back to "format cells" it tells me that
my dates are indeed dates. the error creates cascading errors that
ultimately disallow summing collumns.

suggestions?

 

[Jim Thomlinson]

Changing the cell format to Date does not change the underlying data type of
the values stored in the cell. Try this. double click on the cell and then
hit enter. The data will now be converted from Text to Date. That is a rather
tedious process if you have lots of cells. In that case Place a 1 in any
unused cell. Copy the Cell with the 1 in it. Select the Dates you want to
convert. Select
Edit -> Paste Special | Multiply

Your text will now be converted to dates and your formulas should respond
appropriately...

 

[flyfisher]

so, i inserted a new collumn, copied my old date collumn and pasted it
into the new collumn and formatted it as date. changed the references
in my formulae, and everything is groovy.

 

[Pecoflyer]

Glad we could be of help!


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !