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] > > -- S pozdravem Jan Beránek
