ExcelBanter - How to change all

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to change all - fields to + field (https://www.excelbanter.com/excel-discussion-misc-queries/205803-how-change-all-fields-field.html)

Rockbear

How to change all - fields to + field

Hi all
How can I change from -to plus in a worksheet

The cells have now negative and I want all to be positive, how to do it?

eks :
A1 A2 A3 A4
-214 683 -384 454
want to change to
A1 A2 A3 A4
214 -683 384 -454
--
Just a regular user :)

Mike H

How to change all - fields to + field

Hi,

Multi-posting isn't helpful to you or the people here who give their time to
answer questions. See your other post.

Mike

"Rockbear" wrote:

Hi all
How can I change from -to plus in a worksheet

The cells have now negative and I want all to be positive, how to do it?

eks :
A1 A2 A3 A4
-214 683 -384 454
want to change to
A1 A2 A3 A4
214 -683 384 -454
--
Just a regular user :)

All times are GMT +1. The time now is 05:47 AM.