Also, if you want to type in a date value, and not a mathematical calculation/formula, don't start off the string typed in with that = sign.
Just tested it in a new spreadsheet, and if I simply type in 2/5, it renders as 2 May, but if I type in =2/5, it renders as 0.4. HTH Jacob Kruger Blind Biker Skype: BlindZA '...Fate had broken his body, but not his spirit...' ----- Original Message ----- From: "David Griffith" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, February 06, 2008 2:10 AM Subject: Re: [Blind-Computing] Need help with Excel > 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
