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) 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
