# Thread: Formating cells to show Calculations (2003)

1. ## 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. ## Re: Formating cells to show Calculations (2003)

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

3. ## 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

4. ## 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. ## 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. ## Re: Formating cells to show Calculations (2003)

Thanks Steve that is exactly what I was looking for.

7. ## 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 '

8. ## 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
•