View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_42_] Steve[_42_] is offline
external usenet poster
 
Posts: 9
Default extract decimal component of number

Hi, I need to be able to seperate a number into two components, its decimal
and non decimal component.

For example:
Long Price = 108100
ModifiedPrice= Price/1000 (ie. 108.100)

I need to store these value in two different varibales
numbercomponent = ? (108)
decimalcomponent= ? (.100)

Thank you