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