Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: How do you create a % format type?

    Hello,

    I am having a problem getting a % sign for this format 99.55%. I have tried creating the format using the Format Cells "Custom" function, but I am unable to create a format type. Is there another way create this format?

    Appreciate any help on this issue. Thank you.

  2. #2
    Join Date
    May 2009
    Posts
    258
    You must be storing the percent value as 99.55 instead of .9955, which would be why you are having problems.

    The following format should get you what you want:
    Code:
    0.00"%"
    The other option would be to divide the numbers by 100 and use the standard percent format.

    Regards,

    Ax

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    Woo hoooooo! You are the best Ax.

    Thank you

  4. #4
    Join Date
    May 2009
    Posts
    258
    Great, glad to hear it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •