Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm look for a macro that will check the number of decimal places in a range
of values. I would like to have a pop up box alert the user when a cell is found in that range that contains more than 3 decimal places. For example if the numbers in a range are 50.35, 25.2, 35.235, and 35, the macro would stop on that cell and deliver a pop up box showing me that it contains more than 3 decimal places. I can create an excel formula to check the information: =if(B2<trunc(b2,2,"error",B2) however I don't know enough VBA to get this fomula into a macro to check a range. Any help would be great. Thanks Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
Excel defaulting to 3 decimal places when using the gen. format | Excel Discussion (Misc queries) | |||
Max decimal places | Excel Discussion (Misc queries) | |||
decimal places within a formula | Excel Discussion (Misc queries) |