ExcelBanter

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

Ligaya

formatting
 
I have figures in a column (in Excel) with minus signs which i want to copy
and appear in another column as positve numbers (without the minus sign)so
that when i do the mail merge, the numbers appear on the document as positive
numbers.

Marcelo

formatting
 
Hi Ligaya,

try to make a formula as =ABS(a2), and copy it down, (assuming that the
figures are on the column A.

hope this helps
Regards from Brazil
Marcelo

"Ligaya" escreveu:

I have figures in a column (in Excel) with minus signs which i want to copy
and appear in another column as positve numbers (without the minus sign)so
that when i do the mail merge, the numbers appear on the document as positive
numbers.



All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com