2014-10-22 23:03 GMT+02:00 Vincent A. Juliano <vjuli...@optonline.net>:
> Johnny, I’m talking about the OO.oo text table not the spreadsheet perhaps > that’s where the difference lies. > Oh, sorry for that. I don't know why I missed that. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > > 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 > >
