Re: Time Sheet:Suggestion from an outsider to fix $ in spreadsheet= use find and replace - Don Minow

[DON MINOW <dm...@comcast.net>]

> On March 27, 2020 at 3:19 PM David Belina <db...@comcast.net> wrote:
> 
> 
>     Try just selecting Number as that seems to be what you want.  Does your screen look like the attached?
> 
> 
>      
> 
> 
>     On March 27, 2020 at 2:47:46 PM, Jan Macdonald (jmacbelltown@gmail.com mailto:jmacbelltown@gmail.com ) wrote:
> 
>         > >          
> >         Hello Johnny,
> > 
> >         My time sheet was originally in Excel and must have been automatically formatted to OpenOffice when I originally saved it on my Mac. So possibly the dollar sign could have defaulted from this transition? When the spreadsheet is open I go to format ~ cell protection ~ numbers, then I have a list starting with:
> > 
> >         All
> >         User ~ defined
> >         Number
> >         Percent
> > 
> >         I have no idea how to change this as I’ve tried several things to no avail. All I need the time sheet column to do is add up my hours and not display a dollar sign. If you know how to change this please share. If not no worries.
> > 
> > 
> >         Thank you!
> > 
> > 
> >         Jan
> > 
> >         > On Mar 27, 2020, at 12:34 PM, Johnny Rosenberg <gu...@gmail.com> wrote:
> >         >
> >         > Den fre 27 mars 2020 kl 00:00 skrev Jan Macdonald <jm...@gmail.com>:
> >         >
> >         >> Hello OpenOffice,
> >         >>
> >         >> Wow ~ this is one complicated program. During my career I used Excel,
> >         >> what a breeze. Then for a fun part-time job post-retirement I was directed
> >         >> to use OpenOffice. It’s a challenge!
> >         >>
> >         >> I have a time sheet that is showing the $ sign in the hour column. So for
> >         >> example if I worked five hours it displays $5.00. How can I remove the
> >         >> dollar sign and still have the format add my hours?
> >         >>
> >         >
> >         > You do it exactly the same way as you do it in Excel, so this should be a
> >         > breeze too.
> >         >
> >         >
> >         >
> >         > Kind regards
> >         >
> >         > Johnny Rosenberg
> >         >
> >         >
> >         >>
> >         >> Thank you!
> >         >>
> >         >> Jan MacDonald
> >         >> ---------------------------------------------------------------------
> >         >> 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
>