Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if there is a decimal point
Hello,
Within a for loop i need to check if and where a value has a decimal point, and then amend/add a decimal point. Ie: 100.11 - 100.11 100.1 - 10.01 100 - 1.00 I have tried convoluted ways o check such as Right(Left(c.value,3),1)="." but it doesn't ever want to... Any ideas, suggestions? Much Appreciated, Janos |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal point | Excel Discussion (Misc queries) | |||
Decimal point | New Users to Excel | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
decimal point | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |