ExcelBanter - How do I get Plus and Minus signs in my additions and subtraction

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I get Plus and Minus signs in my additions and subtraction (https://www.excelbanter.com/new-users-excel/115647-how-do-i-get-plus-minus-signs-my-additions-subtraction.html)

TKM

How do I get Plus and Minus signs in my additions and subtraction

How do I get Plus and Minus signs in my additions and subtraction formats? I
have a report that I exported into Excel and it is missing the "-" and "+"
from the grid. How do I get them back?

ufo_pilot

How do I get Plus and Minus signs in my additions and subtraction

Have you tried to format the cells as TEXT?
Format cells Number(tab)text (list)

"TKM" wrote:

How do I get Plus and Minus signs in my additions and subtraction formats? I
have a report that I exported into Excel and it is missing the "-" and "+"
from the grid. How do I get them back?

All times are GMT +1. The time now is 09:18 PM.