Belleke Well-Known Member Apr 22, 2021 #1 When i enter 1234567899, i want the cell changes automaticly into 12-34.-5678.-9\9 formula, vba Cell Properties, every solution is ok. thanks
When i enter 1234567899, i want the cell changes automaticly into 12-34.-5678.-9\9 formula, vba Cell Properties, every solution is ok. thanks
B bosco_yip Excel Ninja Apr 22, 2021 #2 Try, Custom format to: 00-00\.-0000\.-0\\0 Last edited: Apr 22, 2021