| 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. |
| 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) | |||
Threaded Mode
