Am 30.11.2010 03:15, Mick wrote:
I have not used the Calc program in this format but I used to use an old
suite of programs called DataStar and it was one of the original
integrated packages. When brining dates into Datacalc I had to change
them all to number days with slash bar "/" seperators before inporting.
I don't know that it will work for our Calc but it doesn't take long to
use Find/Replace to change something like this and it just may work.
Good luck.
Yes, OOo can deal with thousands of different number formatas in ~150
languages. Just set up the right locale context, do the import and apply
any locale with any number format _after_ you got the correct values
imported.
It is very important to be clear about the difference between value and
formatting.
In this particular case we've got to importe in US locale context and
replace the wrong year digits because US date "Dec 12" is taken as this
year's 12th of December but we know that it is supposed to be a 2011 date.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
