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

J

JMiB55

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 ?
 
P

Pete McCosh

This is based on the standard monetary format.

Go to Format Cells>>Number>>Custom and paste this;

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a VBA Function return a value in percent format 8
I want Excel to transform the symbol "½" to .5 for me. Possible?? 2
Excel's financial currency format vs. Access currency format 0
How do I format a letter in Excell with double strikethrough N? 2
Format a number as ppm 7
How do I format cell for displaying value in lakhs ? 0
How do I format a cell using symbols within a formula? 3
How do i change format of keyboard? the symbols appear wrong 2

Top