Richard Detwiler wrote:
Brewster: I opened your file, went to cell D2, and entered the formula
=DATEVALUE(C2). It gave me an integer number, 40198, which I knew was
encouraging. Then when I formatted the cell as a date (choosing the
12/31/99 option), it gave me the date 01/20/99, which is what it should be.
Then it's a simple matter of copying cell D2 down through as many rows
as you need.
Richard,
Your application locale is English(US). Brewster has some other locale
setting. This is why the conversion must fail.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
