View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James C. James C. is offline
external usenet poster
 
Posts: 32
Default Variable as percent

Hi everyone,

I have a button that my users can push that will display a message box that
is linked to a cell with a percent value in it. My problem is that when the
user presses the button the msgbox say:

The value of column x is: .158765224

I want this to say, " The value of column x is 15.8%" but i don't know how
to declare my variable properly to do so.

Any help would be appreciated.