Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data type inconsistency
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? -- flyfisher ------------------------------------------------------------------------ flyfisher's Profile: http://www.thecodecage.com/forumz/member.php?userid=473 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113120 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data type inconsistency
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... -- HTH... Jim Thomlinson "flyfisher" wrote: 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? -- flyfisher ------------------------------------------------------------------------ flyfisher's Profile: http://www.thecodecage.com/forumz/member.php?userid=473 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113120 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
data type inconsistency
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. -- flyfisher ------------------------------------------------------------------------ flyfisher's Profile: http://www.thecodecage.com/forumz/member.php?userid=473 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113120 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
data type inconsistency
Glad we could be of help! -- Pecoflyer Cheers - 'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html) really IS fast ! ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113120 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel inconsistency | Excel Discussion (Misc queries) | |||
Wrong data type | Excel Discussion (Misc queries) | |||
XL2003 inconsistency fixed in XL2007? | Excel Worksheet Functions | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
excel macro inconsistency | Excel Discussion (Misc queries) |