remove comma in formula cell output

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I think that this is caused by the usage of the NUMBER_FORMAT() function. Instead of that, I suggest to simply use the ROUND() function, which should not add the comma (as a thousand separator).

    Regards,
    Tobias

    Thread Starter BitEdge

    (@whatwhatwhatwhat)

    So what exactly would I enter into the cell in this case? Thanks

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    you could try e.g.

    =?{ROUND( AVERAGE(I2,I3,I4,I5), 0 )}

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘remove comma in formula cell output’ is closed to new replies.