sum format in formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the sum function by entering
=sum(a1:a5),

in one spreadsheet I am seeing it shown in a strange format:
=SUM(R[-5]C:R[-1]C)

Why is it different in this one spreadsheet and how do I get it back? I
copied a portion from another workbook, but the original workbook shows the
sum the original way.

Thanks for the help.
 
When using the sum function by entering
=sum(a1:a5),

in one spreadsheet I am seeing it shown in a strange format:
=SUM(R[-5]C:R[-1]C)

Why is it different in this one spreadsheet and how do I get it back? I
copied a portion from another workbook, but the original workbook shows the
sum the original way.

Thanks for the help.
Click to expand...
 
thank you both for the help! That did it!

bpeltzer said:
When using the sum function by entering
=sum(a1:a5),

in one spreadsheet I am seeing it shown in a strange format:
=SUM(R[-5]C:R[-1]C)

Why is it different in this one spreadsheet and how do I get it back? I
copied a portion from another workbook, but the original workbook shows the
sum the original way.

Thanks for the help.
Click to expand...
Click to expand...
 
Back
Top