On Fri, 2005-02-25 at 18:02 +1300, Greg Trounson wrote:
> That is one option, but only useful if done before pasting or typing
> data, since OO.o munges the internal representation of the string
> 'march123' to '01/03/23'. Converting that back to text (by means of
> changing the format) just gives a numeric value, in this case '11749'.
>
> In my case I'm importing a large CSV into a new sheet, so preformatting
> isn't an option for me, unfortunately.
<tip author="Jonathon Coombes" subject="Entering text in Calc"
category="Calc">
When you enter values that Calc converts to dates or numbers, you can
override this by forcing it as a string entry. This is done by simply
prefixing your data with the quote (') character.
</tip>
Regards
Jonathon
--
OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss
OOo Knowledgebase - http://mindmeld.cybersite.com.au/
Cybersite Consulting - http://www.cybersite.com.au/
Training4Linux - http://www.training4linux.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
