M
Marie
I first selected the desired cell range, then from the
drop-down menu: Format, Cells, Custom, then created a
custom number format as follows in the Type area:
###-###-####
After that, making sure the range was still selected,
Data, Validation. In the Allow tab select Custom, then
ensure one of the cells in the range that you applied the
custom formatting to is entered into the Formula box,
e.g. =A1
This worked for me, but there may be another way as well.
drop-down menu: Format, Cells, Custom, then created a
custom number format as follows in the Type area:
###-###-####
After that, making sure the range was still selected,
Data, Validation. In the Allow tab select Custom, then
ensure one of the cells in the range that you applied the
custom formatting to is entered into the Formula box,
e.g. =A1
This worked for me, but there may be another way as well.
correct format by using Data Validation?