Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Formatting of % in Excel (Excel 2002)

    I want my user to be able to enter numbers and have them appear with a % sign. I know i can format those cells with percent and 0 decimals but then the user has to type .99 to get 99%. I just want them to type 99 and have it appear 99%. I was going to try to use a worksheet_change macro such as Cells(3, "O").Value = Cells(3, "O").Value & "%" but was thinking there might be a easier way. Can anyone help me with this one? thanks

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    You could just format the cell with a custom format, 0 "%"

    HTH

    Peter

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    Go to Tools, Options and select the Edit tab. Check Enable automatic percent entry.

    You can then enter the actual percent value in all cells formatted as Percentage without the leading decimal point and zeros. You do use the decimal if you want a fraction of a percent.

    Andrew C.

  4. #4
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    I'm running Excel XP on a Windows XP workstation, and I couldn't find Enable automatic percent entry. In fact, I can't ever recall seeing that option in any version of Excel. Have I been missing something?

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Formatting of % in Excel (Excel 2002)

    Tools, Options, Edit; in XL 2000 it's the second box down on the top right-hand side of the dialog.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    Well, d-u-h-h <img src=/S/doh.gif border=0 alt=doh width=15 height=15> , I looked right at it in both 2000 and XP and it just didn't register. And in all the times I have looked at that dialog box, that option has escaped my notice.

    Thanks for your explicit and courteour directions.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    The attached is from XL2002 (XP)

    Andrew C
    Attached Images Attached Images

  8. #8
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting of % in Excel (Excel 2002)

    Yes, I finally found it. Gremlins had it kidnapped there for a while. I even found it in Excel 2000.

    All I had to do was really look...

    Thanks.

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Formatting of % in Excel (Excel 2002)

    Don't feel dumb, I always have to ask someone where the option for "Smart Quotes" is in Word. (Our corporate style guide requires that we DON'T use "Smart Quotes" so we turn them off. In W2000 it's in Tools, Autocorrect, AutoFormat, first checkbox under "Replace As You Type", but usually I can't remember that!)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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