| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Negative format
Hi
How can i make this til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2) So the value in beregnforsikring!$q$1 become negative. regards alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Negative format
Hei Alvin
In very general, what these things do is taking whatever meaningful from the right side of the = and put this result to the lucky winner on the left side. So what you do here is setting the til1pris value, you are not changing the q1 value. But the code is a little mysterious. Please provide some more detail. HTH. Best wishes Harald "Alvin Hansen" skrev i melding ... Hi How can i make this til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2) So the value in beregnforsikring!$q$1 become negative. regards alvin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Negative format
til1pris.Value = FormatNumber( _
Range("beregnforsikring!$q$1").Value * -1, 2) -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi How can i make this til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2) So the value in beregnforsikring!$q$1 become negative. regards alvin |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Negative format
Thanks again tom
Regards alvin "Tom Ogilvy" skrev: til1pris.Value = FormatNumber( _ Range("beregnforsikring!$q$1").Value * -1, 2) -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi How can i make this til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2) So the value in beregnforsikring!$q$1 become negative. regards alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pos & negative format?? | Excel Discussion (Misc queries) | |||
| Negative Time Format | Excel Discussion (Misc queries) | |||
| Format to a negative value | Excel Worksheet Functions | |||
| Negative Number Format () Not available | Excel Discussion (Misc queries) | |||
| How do I format a negative percent? | Excel Discussion (Misc queries) | |||
![Alvin Hansen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
