| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| How to truncate to tenths digits without rounding | Excel Worksheet Functions | |||
| How do I truncate something like this? | Excel Discussion (Misc queries) | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
Threaded Mode
