Frustrating options in Excel vs 2003
I will give that a try!
The problem that I'm having is that I'll enter a mathematical formula to
annulize an account and the next time I go back into the spreadsheet, the
formula is gone and a hard coded number is in its place. I want to keep the
formula because it shows the thought process and allows us to create a
'what-if' scenarios with a budget.
--
Just me!
Have a safe day.
"Sheeloo" wrote:
Enter ' before the = in the formula... this converts them into text
Or if you just want to see what formulae are there then press CTRL-~ to
toggle between seeing the formulae and their results...
"skm" wrote:
I'm new in my company and I'm using last years spreadsheet to work up next
years budget. I've downloaded the numbers from our accounting database but
Excel is converting formulas to numbers. I can't seem to ask the question
right to get help in turning off this feature. Is anyone familiar with the
options to help me? This company is still using Excel 2003
Thank you!
--
Just me!
Have a safe day.
|