| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncate leading digits of large number
I have numbers like 12345678901234. I need a formula that will only have
78901234 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Truncate leading digits of large number
Nevermind--found this in earlier post
"adamp" wrote: I have numbers like 12345678901234. I need a formula that will only have 78901234 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Express a large number in fewer digits $1,264,567.50 = $1.3 M | Excel Worksheet Functions | |||
| How to truncate digits? | Excel Worksheet Functions | |||
| data filtering based on last two digits of large number | Excel Worksheet Functions | |||
| leading zero truncate - how to prevent ? | Setting up and Configuration of Excel | |||
| truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
Hybrid Mode
