Forum Discussion
Getting reid of cell references in part of Excel worksheet in order to enter data in cells
I am analyzing my Visa bills, which I have done forever without any problem (I had my current problem once before but I can't remember how I solved it it). I am trying to type numbers but I get a "reference" to another cell in the spreadsheet, say NR10 when I type the equals sign.
I want to type numbers in these cells to add up the expenses for food or whatever in my Visa analysis spreadsheet in Excel.
Thanks for any help you can give me; this should be the easiest problem to solve but I can't find the solution in the Excel manual or on the web.
PS I'm not trying to delete a "function" in the cell, but a "reference" to another cell in the worksheet.
Thanks for your help. I inadvertently somehow turned off the "Num Lock"; when I then used the key pad (rather than the keyboard) to try and put in numbers things got screwed up.
Now all is well.