On 05/24/2009 03:09 PM, Brian Barker wrote: > > One extra thing I didn't mention before: there is an easy way in Calc > to show the difference between the two sorts of data you have in > column A. Go to View | Value Highlighting (or Ctrl+F8). The text > entries - the majority of your values - will remain black, but the > values entered as dates - with which you are having the problem and > which are numbers - will turn blue. This way you will more easily > see the problem and perhaps be able to decide on your best way forward.
Cool! Nice tip, thanks - I like that better than my method of reformating to date w/text! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
