Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Negative Numbers (Excel 2000 SR1a)

    I have my regional settings set to negative number format set (1.1). In Excel I enter a number e.g 100 and format the cell as negative number, style (1234.10), I click on OK but the number appears as 100 not (100).

    How can I get the format to appear correctly?

    Many thanks

    Regards

    John

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Negative Numbers (Excel 2000 SR1a)

    Type -100 ?
    (only NEGATIVE numbers will get brackets).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Negative Numbers (Excel 2000 SR1a)

    Many thanks.

    Feel free to call me stupid or indeed very stupid, I put it down to me having one of those days!

    Regards

    John

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

    Re: Negative Numbers (Excel 2000 SR1a)

    Are you sure you have a semicolon between the positive and the negative picture clause as follows :

    #,##0.00 ;(#,##0.00)

    Try that formatting, changing th enumber of decimal places as appropriate. It should work. If not could up upload a worksheet with the problem.

    Andrew C.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Negative Numbers (Excel 2000 SR1a)

    Hi John,

    <<Feel free to call me stupid or indeed very stupid>>

    Oh well, Forest, trees, we all have days like that...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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