Hi all,
I would like to introduce a custom format to a range of cells in my work sheet. Basically, I want users to enter a part number as opposed to an item description, so effectively forcing users to enter a part number only. However, I am struggling with using the 'custom' number format option to obtain what I want in terms of number formatting. The problem I have is that my part numbers contain Text and Numbers which can can change, for example, I want to enter a part number in the following format: NPLA-14N276-AA all of the characters in this part number can change but the format will remain the same so for example the next part number may be: MPLA-14290-YA
Is it possible to restrict cells to the number format i require and if possible can the cell be restricted to only accept this format?
Bookmarks