Thread: How to make a VBA Function return a value in percent format
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
  
Posts: 173
Default How to make a VBA Function return a value in percent format
I would like the result to automatically be displayed in "%0.00" format but I cannot figure

John,

Based on the line copied above, I assumed that for whatever reason you wanted the "%" sign in front. If you change the "%0.00" in the function to "0.00%", it will return:

0.10%

As an added bonus, when I ran this on a test sheet Excel recognized the result as a decimal.

Ben
Reply With QuoteReply With Quote