It is in calc When entering data in colume A it will not hold the formatting of how I would like the date to be displayed.
I keep clearing the cell yet the formula in any given cell still has a link to a previous cell Say A06 is 1 Aug when I go to enter a date in cell A115 it puts in the date that has been entered in cell A06 so the date is always displaying as 1 Aug regardless of what cell the data is being in putted into. =SUM(A08:A115) On Wednesday, January 22, 2014 12:35:52 PM, Maurice Howe <maur...@stny.rr.com> wrote: That usually means that the formula is invalid and AOO is waiting for your >to repair it. >Could you show us the formula? Is this in CALC, WRITER or what? > >Maurice Howe > > > >-----Original Message----- >From: Lorna Richard [mailto:lornarichar...@ymail.com] >Sent: Wednesday, January 22, 2014 2:57 PM >To: users@openoffice.apache.org >Subject: clearing a cell > >Why is the delete function not working from me? > >There is a formula calculation that will not clear and not allowing me to >continue > > > >