Normally VBA would be used to handle that circumstance, but this trick is
occaisionally useful:

€¢ Set the DV on the cells
€¢ Format those cells to be Unlocked
€¢ Format the contiguous cells to the right of the DV cells to be Locked.

€¢ For each horizontal pair of cells, merge those two cells
€¢ Turn on sheet protection

Now users can enter any 7-char value into the cells...but they cannot
copy/paste into the DV cells.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"JTEFUN" wrote:

Is there anything else that I could try?


--
JTEFUN


"Ron Coderre" wrote:

Try Data Validation:

Select the range of cells to be impacted
From the Excel main menu:
<data<validation
Allow: Text Length
Data: Equal to
Length: 7
Click [OK]

Note_1: Depending on the Error Alert options you select, you can prevent
non-7-char entries....or just warn the user.

Note_2: Users will stil be able to copy/paste invalid entries in the DV
range. Is that an issue?.

Is that something you can work with?
(Post back with more question)
***********
Regards,
Ron

XL2002, WinXP


"JTEFUN" wrote:

I need to beable to format collumns to only acept 7 characters, but then in
column B only 2 characters is this something that is possible?
--
JTEFUN