how to change percentage symbol (Excel XP)

H

Hershmab

I want to display GBP (£) amounts in pence. Formatting the amounts as
percentages gets the displayed values right but follows the number with the
percentage symbol %.

How can I change the percentage symbol to be a cent (or some other
arbitrary)symbol? In other words the input amount £2.5678 should show as
256.78p
 

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 do I format a figure as cent (e.g. 0.015 displayed as 1.15) 1
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
excel displays "l" instead of "€" symbol for Euro values 3
How to remove the % symbol only 3
How do I change default symbols in Excel 2007? 2
Formatting Columns of Percent Data 2
Changing language of an existing sheet 4
Percentage between two given times in Excel 2

Top