| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing a period and leaving maintaingn a fixed #of numbers
Good Morning,
How Can I combine these two? =substitute(a1,".","") and =left(a1,9) I have a string of numbers and I have a period among those numbers(the period is not in a fixed place), I would like to remove the period and always keep first left nine digits. Lets say 42.254420115600000000, 422542011 Thank you for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all negative numbers leaving only positive numbers | Excel Discussion (Misc queries) | |||
| Determine payback period to reach fixed dollar amount. | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
