Formulae

[Edwinfield]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I have used this version since 2004 and using simple addition formula to a column with no problems,
I tried to add a addition formula to May month's column and it shows the formula as such and not the figure or total of the column checking my schedule is has changed all my totals and replaced them with formula How do I correct this as I have changed nothing??

 

[CyberTaz]

Wellll, you have changed something, you just didn't realize it Most
likely you accidently used the keystroke shortcut for displaying Formulas
rather than their resulting values. It may be Control+` but I can't remember
for sure & don't have a Mac available to confirm. If that isn't it, check in
Excel Help for keyboard shortcuts... Or you can go into Excel> Preferences &
reverse the checkbox status for that preference [which is what's toggled by
the keystroke].

 

[Edwinfield]

Thank you for your kind reply, However I have tried what you have suggested. Nothing happened. That does not mean that you are wrong it means that as a user this area is unknown to me and my understanding of what each function should do is foreign to me

 

[CyberTaz]

No Problem ‹ Try it this way...

Go to Excel> Preferences> View - Window Options, uncheck "Formulas".

If that doesn't resolve the issue please provide a more accurate description
of what the situation is. Is it happening in just the one workbook or does
it happen in all workbooks including new ones? Also, state your exact update
level of both Office 2004 & OS X.

Regards |:>)
Bob Jones
[MVP] Office:Mac