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
