View lables in formula

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

How do I see the labels assigned to cells in the formula bar rather than
the cell designation?

i.e. I want to see: =('Number of units' * "cost per unit') rather than
=(E59*E60)

Thanks Bob
 
I have found that the above question refers to using "natural Language"
in the PC versions. Is this available in the Mac X version?

Bob
 
Thanks
-----Original Message-----
Go to Tools>>Options on the menu bar, select
the 'Calculations' tab and check 'Accept labels in
formulas' check box under 'workbook options'. You should
then be able to type your formula in as :-

=Number_of_Units * Cost_per_Unit

HTH


.
Click to expand...
 
Back
Top