View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ty Ty is offline
external usenet poster
 
Posts: 72
Default Removing 3-4 decimals

I need to remove 3 to 4 decimals in a cells in one column. I know it
has something to do with LEFT and something else. Here is the
example:

7.1.2.5 need to convert it to 7125

Thanks.....