| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum format in formula bar
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum format in formula bar
On the menu bar, select Tools Options, click on the General tab, then
uncheck the 'R1C1 Reference Style'. "LovestheBOSOX" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum format in formula bar
thank you both for the help! That did it!
"bpeltzer" wrote: On the menu bar, select Tools Options, click on the General tab, then uncheck the 'R1C1 Reference Style'. "LovestheBOSOX" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum format in formula bar
Tools Menu - Options - General - R1C1 Style
"LovestheBOSOX" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format & Formula | Excel Worksheet Functions | |||
| Need Custom format, not a formula | Excel Discussion (Misc queries) | |||
| Format\Formula Help | Excel Worksheet Functions | |||
| Conditional format with a formula | Excel Worksheet Functions | |||
| formula based on format | Excel Discussion (Misc queries) | |||
Hybrid Mode
