Jan, The cell is formatted to display numbers as money ($). It should be formatted as either plain integer, decimal or time (hh:mm:ss).
As a courtesy I have sent a copy of this to you as you may not be subscribed to the users group mailing list. Please reply to: users@openoffice.apache.org so that all users can assist you if you have any further questions. Sent from my iPhone > On Mar 26, 2020, at 6:00 PM, Jan Macdonald <jmacbellt...@gmail.com> wrote: > > 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