format cell

[VbaHell]

Good afternoon all

I am looking for help please on two areas

First is it possible to format a cell to restrict the number of Characters and format IE.
000012345-0015
000014564-0034

I would like to have the dash automatically put in and make sure the number of Characters are correct

Second Is it possible to make these unique so you cannot enter the same reference in the same column

Any help would be appreciated

 

[Akashwani]

Hi

Highlight your range of cells, right click, Format Cells, Number, Custom and paste this into the "Type" box 0000000-0000

To prevent the length of characters from being too small or large, highlight your range of cells and go to Data Validation press Alt-D-L select Text Length from the Drop Down, Select Equal to in the Data Drop Down, type in how many characters should be entered.

I'm not sure how you can stop duplicates in the column from being entered.

I hope this helps a bit.

Ak

 

[VbaHell]

Thank you for you help on this