Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |