format cell

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,206
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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,296
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top