View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Data Analyst Data Analyst is offline
external usenet poster
 
Posts: 10
Default Removiing decimals from an excel number

Here is the issue: I have numbers like this one - 10000.01.01.200

I just want the prime number 10000. How can I do that? I tried Ctrl+F and
replace but is there a more efficient way?

Thanks!