ta thuy wrote:
Dear sir/madam,
I have a question about using open office spread sheet. I used google to find
out the answer but I can't. And I find your website, so please help me in this
situation.
My question is very simple, but I don't know how to fix it.
It is when I type, for example, 3.3.3 into one cell of a sheet, it changed into
03/03/03 (mean March 03rd 2003).
I tried many ways to change it to 3.3.3 but I can't.
So please help me about this, I thank you very much for your consideration.
Thuy Ta - From VietNam.
Hi Thuy Ta
The answer is simple, this is an automatic feature within spreadsheets
to try and detect the difference between dates, pure numbers and
character strings. My recommendation would be to type this string as
'3.3.3 as the ' (a single quote mark) tells a spreadsheet program that
what follows is a string of characters and not a number.
I hope that helps
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
