| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Truncate a series of numbers
Hi -
I am trying to truncate these numbers to only 2 sections; example: from 51230. 14.6.24 to 51230.14 There can be multiple quantities of numbers in each section; it can be 51230.1434.66.789. I used the function below but it leaves a "." at the end which I do not want. As in the example I need to have just 51230.14 Any suggestions? Thanks =LEFT(K2,FIND(CHAR(7),SUBSTITUTE(K2,".",CHAR(7),2) )) Thanks in advance, Carrie -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a series of numbers | Excel Discussion (Misc queries) | |||
| Can't sum a series of numbers | Excel Discussion (Misc queries) | |||
| truncate numbers from millions to thousands | Excel Worksheet Functions | |||
| Series of numbers | New Users to Excel | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Threaded Mode
