Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formating cells to show Calculations (2003)

    Hello,
    I was wondering if there is a way to display in a cell the following $2,100-$2,100 When I print it or display it it shows the net effect. I would like it to show both numbers in a cell. I am also using this number for calculations so it needs to be formatted similar to accounting with the dollar sign. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formating cells to show Calculations (2003)

    I'm afraid I don't understand. Could you elaborate?

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formating cells to show Calculations (2003)

    If you use a single quote as the first character, then whatever you place after that will be shown just as you type it without the quote. But, like Hans, I'm confused by your question: 2100-2100 = 0. If you want $ - in the cell (acounting formatting for zero), then just place a zero in the cell and format it as Accounting. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formating cells to show Calculations (2003)

    I need to show both the negative number and the positive number in the cell. So the cell needs to reflect the negative positive amount$2,100 and the negative amount $2,000. I hope that helps.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formating cells to show Calculations (2003)

    If I understand you correctly, you will need to have the number in one cell (to be used as a number in calculations) and the "display" in a separate cell

    For example in A1:
    2100
    (use references to A1 when you need the number)

    And in B1 have something like:
    =TEXT(A1,"$#,##0")&"-"&TEXT(A1,"$#,##0")

    Steve

  6. #6
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formating cells to show Calculations (2003)

    Thanks Steve that is exactly what I was looking for.

  7. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Formating cells to show Calculations (2003)

    Hi,

    A somewhat different approach would be to use a custome number format.

    If you use Foemat|Cells|Number and choose 'Custom', you can type Alt-0177 followed by the required 0s, #s or ?s, thousands separators etc into the 'Type' box, you get get output along the lines of '
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  8. #8
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formating cells to show Calculations (2003)

    Will try it. Thanks.

Posting Permissions

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