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 wrote:
>
> 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 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