Brewster Gillett wrote:
It's only 22K, so shouldn't have any difficulty getting through...
....thanks for your efforts.
Brewster
The values have been imported/pasted/entered as text (sequence of digits
with slashes). Dates you can calculate with have to be numbers.
Your locale settings assume D/M/Y dates, so 1/30/99 is not a numeric
expression (month=30). 1/2/99 is a numeric expression (1st of Feb), but
obviously it is meant to be Jan, 2nd.
Since you imported all the values as text, you see the leading apostroph
which (luckily) prevents the wrong evaluation.
Tools>Options...LanguageSettings>Languages: Locale = English(USA)
Now all the text values get the leading apostrophe *in order to* prevent
data corruption (keep the user's text values! do not auto-convert user
data!).
When you re-enter some of the values manually, you'll see that you get
numeric values in any format you can freely choose from the number
formatter. The number formatter is pointless with text values.
This is how to re-enter all the dates in one go:
Select them.
Edit>Find...[Ctrl+F]
[More Options]
[X] Current Selection
[X] Regular Expressions
Search: .+ [yes, a dot and a plus]
Replace: &
[Replace All]
I'm sure this helps.
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
