Hello David, Thanks for the information. I have not used the general option under formatting cells. You are right that deleting the contents of the cell does not remove the underlying format. As Jacob pointed out, using a new spreadsheet would eliminate these problems, but as I mentioned, I only create a new spreadsheet for new data and I usually bring a spreadsheet from the previous year or month.
I will try your suggestion and do a general format on the entire spreadsheet the next time. Again, thanks for your help. Lennie At 07:10 PM 2/5/2008, you wrote: >It sounds like you have inappropriate value formats in your cells. >Deleting the cell values will not remove the underlying format, be it date >or number etc. > >Starting from the very basic I would take the following. Steps. >If it is getting that confusing I would personally select the whole >spreadsheet and then go to format cells. I would reset everything to >General and start again. Go to each cell and define the cell format you >want. For example number, date, and so on. > >You can easily do this by pressing the application key on the relevant cell >and then select format cells. Pressing Tab once will put you into the >relevant list of formats from which you can select. You may be able to >press tab again to select further options on a format. For example setting >decimal places under number format or different styles of format under date. > >You probably know all this but I thought it was worth setting this out in >case it helps. > >Regards > >David Griffith > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Lennie Rinaldi >Sent: Tuesday, 05 February 2008 19:14 >To: [email protected] >Subject: [Blind-Computing] Need help with Excel > >Hi, > >I am using Office 2003 and Excel. I usually create a new spreadsheet year to >year by saving the previous year with the current year in the file name. > >My problem is that when I removed old data, the cell still has the format >embedded in it. I tried to clear the cell by going to edit and do a clear >all. When I enter a numeric value, I get some weird number. The same is for >a formatted date function such as =date and I enter a numeric value and I >really got even a more weird result. Try to imagine entering today's date as >2/5 and you end up with 2 divided by 5. > >Sorry for the long post, but I tried everything that I can think of and I am >to be honest, frustrated. > >I appreciate any help that I can get. Thanks, > >Lennie > > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/[email protected]/ > To post to this group, send email to > [email protected] > To unsubscribe from this group, send an email to >[EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject >or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team >http://www.jaws-users.com/BlindComputing.php > If you wish to join the JAWS Users List send a blank email to the >following address: > >[EMAIL PROTECTED] >______ >Blind-Computing mailing list >[email protected] >http://mail.jaws-users.com/mailman/listinfo/blind-computing_jaws-users.com > > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/[email protected]/ > To post to this group, send email to > [email protected] > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/BlindComputing.php > If you wish to join the JAWS Users List send a blank email to the > following address: > >[EMAIL PROTECTED] >Blind-Computing mailing list >[email protected] >http://mail.jaws-users.com/mailman/listinfo/blind-computing_jaws-users.com Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/[email protected]/ To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/BlindComputing.php If you wish to join the JAWS Users List send a blank email to the following address: [EMAIL PROTECTED] Blind-Computing mailing list [email protected] http://mail.jaws-users.com/mailman/listinfo/blind-computing_jaws-users.com
