Victor Chapman <victor.chapman <at> sympatico.ca> writes: > .... > The original column of dates was imported as text. I think that I need > to format the column as containing dates, but I also need to go through > a conversion, perhaps of the original text dates to give them a date > value. I don't know how to do this. > I believe you are correct. Changing the format of the cells will not alter the original character of the contents. Testing on my test file, I find that the original text acquires a preceding apostrophe. If that has happened in your case, a search and replace technique mentioned in the Calc forum is Search ^. and Replace & You need to select More Options > Regular Expressions on the Search and Replace dialog.
If there is no apostrophe, you can convert using the function DATEVALUE in the adjoining column, format that column to show the resulting values as dates, copy the column then special paste making sure you deselect formulas. Substitute the new dates for the old. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
