2014-10-22 21:27 GMT+02:00 Vincent A. Juliano <[email protected]>:
> 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 <[email protected]> > wrote: > > > 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <[email protected]>: > > > >> 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: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
