HELP FORMATING COLUMNS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
This won't work if values are pasted, only typed. Do data>validation, select
allow text length, then equal to and finally put 7 in the box, then create
an error alert message with something like "You need to type 7 characters"

repeat for column B and use 2 instead
 
I did what you said and its not working. I want only 7 characters to fill
the column even though when I paste 20 characters into that 7 character field.
--
JTEFUN


Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
 
Is there anything else that I could try?


--
JTEFUN


Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
 
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 said:
Is there anything else that I could try?


--
JTEFUN


Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top