ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Control + Grave accent doesn't show formula result, format is gene (https://www.excelbanter.com/excel-worksheet-functions/172408-control-grave-accent-doesnt-show-formula-result-format-gene.html)

Twishlist

Control + Grave accent doesn't show formula result, format is gene
 
Have checked to ensure cell is formatted as General, not text, but still
Control + Shift + Grave Accent doesn't toggle - I'm still viewing formula
rather than result.
Control + Grave accent (without shift) makes all the columns in the
worksheet jump to a new width (wider). Any insight?

Twishlist

Control + Grave accent doesn't show formula result, format is gene
 
I've just resolved this...I have to save the new workbook before I make the
link, otherwise the value won't display, just the path. If link is made
before new workbook is saved, it won't display result unless I redo the link,
not matter how much grave accenting goes on.

"Twishlist" wrote:

Have checked to ensure cell is formatted as General, not text, but still
Control + Shift + Grave Accent doesn't toggle - I'm still viewing formula
rather than result.
Control + Grave accent (without shift) makes all the columns in the
worksheet jump to a new width (wider). Any insight?



All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com