LEDEAUT Stephane wrote: > I am using the spreadsheet into XXE and I have always the text Nan which > describes Not a number when it is effectively not a number. > > My problem is that I would like to replace this text by a blank instead > of a Nan. > > Does it exist an easy way to replace this text by a blank ? >
No. There are two ways to format a number which is the result of a formula. [1] Specify a format such as "0.###E0" in the formula editor. Unfortunately, Java's number formats are no expressive enough to change the way a NaN is displayed. [2] Integrate the formatting in the formula itself. Using intermediate variables makes this workable. Example you orignal formula is: --- = 2 + "foo" --- (which gives NaN) Rewrite it as follows: --- x = 2 + "foo" =if(checknumber(x), x, "") ---
