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