View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Blass Robert Blass is offline
external usenet poster
 
Posts: 35
Default How to truncate digits?

Using Excel 97

7018 kbps (857 kB/s)
13043 kbps (1592 kB/s)

Above is an example of lines of data I get generated from a speed
test. How do I truncate those last parts, the parts beyond the (
digit?

I'm needing 7018 kbps (857 kB/s) to simply appear as 7018
And also needing 13043 kbps (1592 kB/s) to simply appear as 13043

Thanks people