How do I format a figure as cent (e.g. 0.015 displayed as 1.15)
 

I would like to format number expressed in Euro (same with Dollars) in cent.
e.g. instead of having "0.0123 ‚¬" I would like to see "1.23 ct"

Using percentage symbol I get the right figures but with the wrong symbol:
format: "0.00 %" -- figure is displayed as "1.23 %"

Is it possible to change or remove the %symbol ?

Is there another solution ?

How do I format a figure as cent (e.g. 0.015 displayed as 1.15)
 

This is based on the standard monetary format.

Go to Format CellsNumberCustom and paste this;

_-* #,##0.00 ct_-;-* #,##0.00 ct_-;_-* "-"?? ct_-;_-@_-

"JMiB55" wrote:

I would like to format number expressed in Euro (same with Dollars) in cent.
e.g. instead of having "0.0123 ‚¬" I would like to see "1.23 ct"

Using percentage symbol I get the right figures but with the wrong symbol:
format: "0.00 %" -- figure is displayed as "1.23 %"

Is it possible to change or remove the %symbol ?

Is there another solution ?