Ely, that did it!
And Jan, thanks for your previous helpful emails.
Kyle
Ely Schoenfeld wrote:
How are you getting the csv file into OOo calc?
When you open it, there should appear a window where to change settings of
"comma" or "tab" as separator and those things.Below that, appear a few
lines of the file showing how columns will be imported.
If you look closely, on top of each column, there is a darker gray header.
Each column says "Default" as a default (he he) you can change settings by
right clicking on each column header. So, find the column where "3.23.01"
appear, right click on the "heder" row and select "text".
I hope I made my self clear.
Ely
2008/10/16 Kyle Nitzsche <[EMAIL PROTECTED]>
Thank you Jan.
Unfortunately, the spreadsheet is a csv file that is generated from a
database, so I can't add the apostrophe because the data is derived
mechanistically from the database and that data does not have a leading
apostrophe (and shouldn't have one).
Also, I can't set the cell format before I open it, since the file is
generated. I need to open it and then do something to make it display
correctly.
Any other suggestions?
Kyle
Jan Beranek wrote:
Hello,
you have at least two possibilities, how to do it.
1) write the value like this: '3.23.01
- the mark ' is important, it tels calc that input is text value
2) prior to writting set format the cell to text
regards
Jan
On Thu, Oct 16, 2008 at 4:45 PM, Kyle Nitzsche
<[EMAIL PROTECTED]>wrote:
I have thousands of cells whose actual content is something like this:
"3.23.01".
Calf insists on seeing this as a Date and displaying it in whatever date
format I have.
If I set the cell format to Text, it now displays it as a number: 36973
(probably the number of days since some time or other.)
I want and need to see the actual text: "3.23.01". (It is not a date, in
fact is is a software version.)
So, how to turn off Calc's automatic treatment of date-like numbers as
date
and just show me the actual text?
Many thanks in advance,
Kyle
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
