ExcelBanter - PROBLEMS WITH FORMATING COLUMNS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - PROBLEMS WITH FORMATING COLUMNS (https://www.excelbanter.com/excel-discussion-misc-queries/148866-problems-formating-columns.html)

JTEFUN

PROBLEMS WITH FORMATING COLUMNS

I'm trying to format a column to only allow 7 characters and it's still not
working, can anyone help me?
--
JTEFUN

Toppers

PROBLEMS WITH FORMATING COLUMNS

Assuming column is column A, highlight column (or range)

Data=Validation

Allow: Custom

Formula: =LEN(A1)=7

This will allow only a length of 7 (no more/no less!)

You can add your own message in "Error Alert"

HTH

"JTEFUN" wrote:

I'm trying to format a column to only allow 7 characters and it's still not
working, can anyone help me?
--
JTEFUN

Rick Rothstein \(MVP - VB\)

PROBLEMS WITH FORMATING COLUMNS

Assuming column is column A, highlight column (or range)

Data=Validation

Allow: Custom

Formula: =LEN(A1)=7

This will allow only a length of 7 (no more/no less!)

You should also Format the column as Text so as to allow entries of numbers
with leading zeroes (such as, 0001234).

Rick

Toppers

PROBLEMS WITH FORMATING COLUMNS

Good point ... thanks!

"Rick Rothstein (MVP - VB)" wrote:

Assuming column is column A, highlight column (or range)

Data=Validation

Allow: Custom

Formula: =LEN(A1)=7

This will allow only a length of 7 (no more/no less!)

You should also Format the column as Text so as to allow entries of numbers
with leading zeroes (such as, 0001234).

Rick

All times are GMT +1. The time now is 09:57 PM.