Re: Time Sheet

2020-03-27 Thread Johnny Rosenberg
Den fre 27 mars 2020 kl 00:00 skrev Jan Macdonald : > 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

Re: Time Sheet

2020-03-27 Thread David Belina
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

Re: Time Sheet

2020-03-27 Thread Jan Macdonald
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,

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

2020-03-27 Thread DON MINOW
> On March 27, 2020 at 3:19 PM David Belina 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 >

Re: Calc und n-te Wurzel

2020-03-27 Thread Semmel
Moin, Alois Klotz schrieb am 26.03.2020 um 20:29: Hallo! dazu muss man wissen, dass die Wurzel aus einer Zahl auch als Potenz angegeben werden kann: also dritte Wurzel aus 8 ist: 8^1/3 -  also 8 hoch ein Drittel Das hier berechnet z.B. die 7. Wurzel aus dem Wert in der Zelle A1