You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "Vincent A. Juliano" <vj...@optonline.net> on 2014/10/22 16:52:44 UTC
Entering fractions and mixed numbers into my tables.
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Entering fractions and mixed numbers into my tables
Posted by Brian Barker <b....@btinternet.com>.
At 10:52 22/10/2014 -0400, Vincent A. Juliano wrote:
>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.
When you say "table", do you mean a table - in a text document? I'm
guessing that you actually mean a spreadsheet.
>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.
I think all you need to do is to lose that hyphen (or minus sign).
Try "4 2/3". You can immediately see that this works if you enter
something like "4 4/3". Fractions less than one can be entered as,
for example "0 2/3".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Entering fractions and mixed numbers into my tables.
Posted by Johnny Rosenberg <gu...@gmail.com>.
2014-10-22 23:03 GMT+02:00 Vincent A. Juliano <vj...@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 <gu...@gmail.com>
> wrote:
>
> > 2014-10-22 21:27 GMT+02:00 Vincent A. Juliano <vj...@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 <gu...@gmail.com>
> >> wrote:
> >>
> >>> 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vjuliano@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-unsubscribe@openoffice.apache.org
> >>>> For additional commands, e-mail: users-help@openoffice.apache.org
> >>>>
> >>>>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> >> For additional commands, e-mail: users-help@openoffice.apache.org
> >>
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Re: Entering fractions and mixed numbers into my tables.
Posted by "Vincent A. Juliano" <vj...@optonline.net>.
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 <gu...@gmail.com> wrote:
> 2014-10-22 21:27 GMT+02:00 Vincent A. Juliano <vj...@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 <gu...@gmail.com>
>> wrote:
>>
>>> 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vj...@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-unsubscribe@openoffice.apache.org
>>>> For additional commands, e-mail: users-help@openoffice.apache.org
>>>>
>>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Entering fractions and mixed numbers into my tables.
Posted by Johnny Rosenberg <gu...@gmail.com>.
2014-10-22 21:27 GMT+02:00 Vincent A. Juliano <vj...@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 <gu...@gmail.com>
> wrote:
>
> > 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vj...@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-unsubscribe@openoffice.apache.org
> >> For additional commands, e-mail: users-help@openoffice.apache.org
> >>
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Re: Entering fractions and mixed numbers into my tables.
Posted by "Vincent A. Juliano" <vj...@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. 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 <gu...@gmail.com> wrote:
> 2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vj...@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-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Entering fractions and mixed numbers into my tables.
Posted by Johnny Rosenberg <gu...@gmail.com>.
2014-10-22 16:52 GMT+02:00 Vincent A. Juliano <vj...@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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Re: Entering fractions and mixed numbers into my tables
Posted by Brian Barker <b....@btinternet.com>.
At 11:47 22/10/2014 -0400, Vincent A. Juliano wrote:
>On Oct 22, 2014, at 11:32 AM, Brian Barker wrote:
>>At 10:52 22/10/2014 -0400, Vincent A. Juliano wrote:
>>>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.
>>
>>When you say "table", do you mean a table - in a text document? I'm
>>guessing that you actually mean a spreadsheet.
>
>I meant text tables.
Sorry for suggesting otherwise. I'm less familiar with arithmetic in
tables and didn't immediately find how to do this in tables. But as
you say, it's the same.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Entering fractions and mixed numbers into my tables
Posted by "Vincent A. Juliano" <vj...@optonline.net>.
I meant text tables.
Eureka!!!! it works. Migliore di thank you’s
On Oct 22, 2014, at 11:32 AM, Brian Barker <b....@btinternet.com> wrote:
> At 10:52 22/10/2014 -0400, Vincent A. Juliano wrote:
>> 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.
>
> When you say "table", do you mean a table - in a text document? I'm guessing that you actually mean a spreadsheet.
>
>> 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.
>
> I think all you need to do is to lose that hyphen (or minus sign). Try "4 2/3". You can immediately see that this works if you enter something like "4 4/3". Fractions less than one can be entered as, for example "0 2/3".
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org