View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hershmab Hershmab is offline
external usenet poster
 
Posts: 35
Default 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