| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return fractional part of values
In an internal VBA calculation, I need to return the fractional part of a
value in a cell. For example, 5.35 returns 0.35 7.00 returns 0 I thought: dValue = ActiveCell.Value Mod 1 would do it, but this doesn't work...don't know why... Thanks much in advance for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return part of a text string | Excel Discussion (Misc queries) | |||
| can a function return part of it's result in italics? | Excel Worksheet Functions | |||
| How do I isolate the Fractional part of a number in Excel VB? | Excel Programming | |||
| return left most part of cell | Excel Worksheet Functions | |||
| Help needed summing fractional values which have been rounded up | Excel Discussion (Misc queries) | |||
Threaded Mode
