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