I have a table of data on employee in excel 2003, I would like to predefine the format for entering my cell or at least an entire range of cell (column). For example, when I write a bank account number, I would not have to enter dashes 001-5555555-56 but unable to enter the numbers and format, No account is registered automatically. Same for the phone number... Thank you for your help.
Bookmarks