ExcelBanter - how to change percentage symbol (Excel XP)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to change percentage symbol (Excel XP) (https://www.excelbanter.com/excel-discussion-misc-queries/212768-how-change-percentage-symbol-excel-xp.html)

Hershmab

how to change percentage symbol (Excel XP)

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

Gary''s Student

how to change percentage symbol (Excel XP)

Format Cells... Number Custom 0.00"p"
--
Gary''s Student - gsnu200818

All times are GMT +1. The time now is 04:29 AM.