Can you send a sample with some testing data? I'm afraid I cannot help you without try...
You can send the data directly to my email, [EMAIL PROTECTED] Jan On Thu, Oct 16, 2008 at 5:54 PM, Kyle Nitzsche <[EMAIL PROTECTED]>wrote: > 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] > > -- S pozdravem Jan Beránek
