Hi Jan
At the top of the column above line 1 there is usually a letter from A - Z
or similar
Right click on the letter and it should come up with a "option box that ha
Format Cells. Click on this button and another box will come up with other
options that has some or all of the following options Date, Time, Currency
Number Custom etc Click on the number option if you just want ordinary
numbers and it will give you further options as to where you want decimal
places or click on the time and it will arrange the times for you. Then save
the spreadsheet
Hope this helps
Richard Beeston
-----Original Message-----
From: Jan Macdonald
Sent: Friday, March 27, 2020 9:20 AM
To: users@openoffice.apache.org
Subject: Time Sheet
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?
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
