I have a number of cells with 000000099999, and want to truncate the
leading zeros off. I have tried several different things with
formatting and can't figure it out, can someone help?

thanks