Cell content FLOAT ?

Hi,

Is there any function or any way by which i get to know that cell content is integer or Floting?

I need to findout in my VBA code if the cell content is floating if yes then truncate the contents to 6 decimal places

My vBA code is something like below

I want code to check that Cf1 and CF2 is float if yes

then trun cate to 6 decimal places like

Please Login or Register  to view this content.

Please help how to do that Iam stuck up with this
Many thanks,
Ankur

Hi,
Thanks for the useful information however this might not solve my purpose by using the expressions above I can convest the cell vale, content of a variavle to float or Int however in my excel sheet its having lots of data which are of type integers, float & date & alpanumerics also (varchars)

So if I set the varaible to float it will convert all the cell data of sheet to float which i dont want.

I want a func which can determine that cel content or variable is float then perfom a action.

Do we have any inbuilt function like that in VBA ?

please help