| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert negative decimals to positive
grateful for any advices on converting negative numbers with decimals to
positive; if you multiply by -1 you loose the decimals (well i do!) -- with kind regards Spike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert negative decimals to positive
<you loose the decimals
You shouldn't. Maybe a question formatting, or just widen the column. Another way: =ABS(A1) -- Kind regards, Niek Otten "Spike" wrote in message ... grateful for any advices on converting negative numbers with decimals to positive; if you multiply by -1 you loose the decimals (well i do!) -- with kind regards Spike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
convert negative decimals to positive
Many thanks. Totally elementary i had dimmed the variable as long!!!
Sorry -- with kind regards Spike "Niek Otten" wrote: <you loose the decimals You shouldn't. Maybe a question formatting, or just widen the column. Another way: =ABS(A1) -- Kind regards, Niek Otten "Spike" wrote in message ... grateful for any advices on converting negative numbers with decimals to positive; if you multiply by -1 you loose the decimals (well i do!) -- with kind regards Spike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
| How to convert positive figures to negative ones? | Excel Discussion (Misc queries) | |||
| How do I convert a column of numbers from positive to negative? | Excel Discussion (Misc queries) | |||
| Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
| Convert positive # to negative | Excel Discussion (Misc queries) | |||
Hybrid Mode
