On Wed, 2004-04-14 at 18:09, Rohan Walsh wrote:
Hi, I'm using gnumeric 1.2.1 on fc1. I have a cell formatted as currency displaying no decimal places (displaying the whole dollar value). The value is calculated by a formula. Is it possible to get gnumeric to use the whole dollar value as input for other formulas rather than the actual value?
We always use the real value rather than the displayed value. To have the real value match the displayed value just wrap the formula in that cell with a round() function call. Andreas -- Andreas J. Guelzow Taliesin Software, Shelties, Pyrsheps and Shetland Sheep
Attachment:
signature.asc
Description: This is a digitally signed message part