> On March 27, 2020 at 3:19 PM David Belina <dbel...@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 (jmacbellt...@gmail.com
> mailto:jmacbellt...@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
> > <gurus.knu...@gmail.com> wrote:
> > >
> > > Den fre 27 mars 2020 kl 00:00 skrev Jan Macdonald
> > <jmacbellt...@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-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
>