ExcelBanter - Truncate leading digits of large number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Truncate leading digits of large number (https://www.excelbanter.com/excel-discussion-misc-queries/191752-truncate-leading-digits-large-number.html)

adamp

Truncate leading digits of large number

I have numbers like 12345678901234. I need a formula that will only have
78901234

adamp

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

All times are GMT +1. The time now is 04:14 AM.