So I know my title is weird, but here's what I'm hoping to do.

I have an input mask applied to an entire column, which is serving as an identifier number for individual people in a sheet. The mask is in the format "FA-#####-##". If I type 1234567 into the cell, the mask applies perfectly, and when looking at the cell on the screen, it shows FA-12345-67. If I click on the cell, and look at the formula bar, it shows the initial input of 1234567. I'm curious, is there a way to be able to type 1234567 into the cell, and have it not only show FA-12345-67 number on the screen, but also modify the cell so it now contains the full thing in the formula bar, and not just the numbers I input? I'm hoping this makes sense, and I'll grab some screenshots if it's needed. Will it take some VB programming to do it, or is there an easier way?