answersLogoWhite

0

It depends on how the negative sign got on the cell. If you typed it, then edit the cell and remove the negative sign. If it was calculated and you want to show only the number without a sign, you can do one of two things:

  1. Multiply the results times -1.
  2. Use the ABS function to return the absolute value of the number. =ABS(2-3) will return 1 instead of -1.
User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How you enter account no in Excel sheet it not except?

This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.


How do you make a result sheet in Excel?

how to create a excel sheet


What is the full form of PFA in Excel sheet?

Pfa the excel sheet


What are words entered into excel sheet called?

labels or cell content


What is the difference between Excel sheet and spread sheet?

They are the same thing, excel is Microsoft's spreadsheet programme.


How do you make a cover sheet in excel?

Add a sheet


What does the number in parentheses mean on balance sheet line item?

the number is negative.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


How is a sheet made active on excel 2007?

Select the sheet.


Which tab and which group in the ribbon houses the command button that allows you to remove duplicates in the excel sheet?

view tab, show group


What is a model in excel?

A spread sheet


How do you get the sheet to no longer be in a group?

To remove a sheet from a group in spreadsheet software like Microsoft Excel or Google Sheets, right-click on the sheet tab you want to ungroup and select "Ungroup" or "Ungroup Sheets." If you're using Excel, you can also go to the "View" tab and click "Unhide" or simply click on a different sheet that is not grouped. In Google Sheets, just click on any sheet tab that is not part of the group. This will effectively separate the selected sheet from the group.