| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula bar displays "=RC[-12]+RC[-11]". how to get normal view?
Hi,
The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]" but I don't remember changing any setting. Does anybody know how to get back to normal view in the formula bar, i.e "=D9+D10"? Thanks Laurent |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula bar displays "=RC[-12]+RC[-11]". how to get normal view?
It remembers the settings from the last workbook opened.
Tools - Options - general Un-check RICI "Laurent" wrote: Hi, The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]" but I don't remember changing any setting. Does anybody know how to get back to normal view in the formula bar, i.e "=D9+D10"? Thanks Laurent |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula bar displays "=RC[-12]+RC[-11]". how to get normal view?
Tools Options General and uncheck R1C1 Reference Style
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Laurent" wrote in message ... Hi, The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]" but I don't remember changing any setting. Does anybody know how to get back to normal view in the formula bar, i.e "=D9+D10"? Thanks Laurent |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula bar displays "=RC[-12]+RC[-11]". how to get normal vie
Thank you!
"Mike" wrote: It remembers the settings from the last workbook opened. Tools - Options - general Un-check RICI "Laurent" wrote: Hi, The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]" but I don't remember changing any setting. Does anybody know how to get back to normal view in the formula bar, i.e "=D9+D10"? Thanks Laurent |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
| Remove "INV" from worksheet in Normal View | Excel Discussion (Misc queries) | |||
| Print in Excel displays "save as" screen and never prints. | Excel Discussion (Misc queries) | |||
| Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
| Discrete "Normal" Curve Function? | Excel Worksheet Functions | |||
Linear Mode
