The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
I'd be very grateful if someone could solve this conundrum.
Attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).ApacheChopper wrote:The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
The display in H7 was exactly what you had requested. The formula value was 0.3125. The numeric cell format (Format → Cells → Numbers → Format code) was # which says to display only the (rounded) integer part but don't display a zero value. Read about format codes in OpenOffice Help → Index → format codes;numbers. A good format code to specify in this situation (nothing shown) is Category → All → Format → General.ApacheChopper wrote:Cell H7 is the one that won't populate.
Users browsing this forum: Google [Bot] and 29 guests