| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Truncate a series of numbers
Thank you - worked great!
Glenn wrote: Hi - [quoted text clipped - 11 lines] Thanks in advance, Carrie Borrowing from an answer I posted earlier today... =SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(K2,".",REPT(" ",99)),198))," ",".") -- Message posted via http://www.officekb.com |
| 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
