| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognizing a whole number instead of a decimal
Please help. What VBA code could automate the recognition of a whole number
instead of a decimal? My pending programming will generate values that are either whole numbers or decimals. I only want to recognize whole numbers. Thank you very much. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recognizing a whole number instead of a decimal
Hi
A general test if n = INT(n) then Best wishes Harald "horsepro001" skrev i melding ... Please help. What VBA code could automate the recognition of a whole number instead of a decimal? My pending programming will generate values that are either whole numbers or decimals. I only want to recognize whole numbers. Thank you very much. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recognizing a whole number instead of a decimal
Assuming the number is in variable myNum
If myNum = Int(myNum) Then ... -- HTH RP (remove nothere from the email address if mailing direct) "horsepro001" wrote in message ... Please help. What VBA code could automate the recognition of a whole number instead of a decimal? My pending programming will generate values that are either whole numbers or decimals. I only want to recognize whole numbers. Thank you very much. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recognizing a whole number instead of a decimal
Thank you!!!
"Harald Staff" wrote: Hi A general test if n = INT(n) then Best wishes Harald "horsepro001" skrev i melding ... Please help. What VBA code could automate the recognition of a whole number instead of a decimal? My pending programming will generate values that are either whole numbers or decimals. I only want to recognize whole numbers. Thank you very much. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Recognizing a whole number instead of a decimal
Thank you!!!
"Bob Phillips" wrote: Assuming the number is in variable myNum If myNum = Int(myNum) Then ... -- HTH RP (remove nothere from the email address if mailing direct) "horsepro001" wrote in message ... Please help. What VBA code could automate the recognition of a whole number instead of a decimal? My pending programming will generate values that are either whole numbers or decimals. I only want to recognize whole numbers. Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to correct the decimal number to the nearest even number | Excel Worksheet Functions | |||
| Add decimal to number | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
Linear Mode
