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] > >
