Johnny, I’m talking about the OO.oo text table not the spreadsheet perhaps that’s where the difference lies.
On Oct 22, 2014, at 4:03 PM, Johnny Rosenberg <gurus.knu...@gmail.com> wrote: > 2014-10-22 21:27 GMT+02:00 Vincent A. Juliano <vjuli...@optonline.net>: > >> Thank you for the suggestion but the hyphen ‘ Does show and when it is >> removed the mixed fraction reverts to the date type numeration. > > > Oh, that's strange… The ' use to show in the formula field but not in the > cell itself, but maybe we are talking about two different things here. > Also pre-formatting the cell to text usually works. > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ > > > > >> Brian Barker’s method seems to work very well so I’ll go with that. >> Again thank you very much. >> >> >> On Oct 22, 2014, at 1:52 PM, Johnny Rosenberg <gurus.knu...@gmail.com> >> wrote: >> >>> 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vjuli...@optonline.net>: >>> >>>> I need to set coordinates for a bulkhead and I use the fraction system. >>>> However, when I try to enter the fractions into the table they end up as >>>> dates. As an example 4-2/3 ends up as >>>> 04/02/03. What must be done to enter mixed numbers into the table and >>>> have them remain mixed numbers. >>>> >>>> >>> If they only are supposed to show up as text, you can add a ' at the >>> beginning: >>> '4-2/3 >>> The ' will not be displayed. >>> >>> Kind regards >>> >>> Johnny Rosenberg >>> ジョニー・ローゼンバーグ >>> >>> >>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >>>> For additional commands, e-mail: users-h...@openoffice.apache.org >>>> >>>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org