How change text setting to number with command or activity in Excel?

in excel itself you can just use the formula “value” it will change it to a number but it will also remove the zeros in front