Prev: Convert Date string to date format
Next: Count of numerical values within a cell
From: htown on 6 May 2010 08:53
I need to ensure each cell has 8 characters throughout a column .
From: Gary''s Student on 6 May 2010 09:01
If we already have data in column A, then in B1 enter:
=IF(LEN(A1)=8,"","bad length")

and copy down. This will reveal bad items

If data is being entered into column A, then just use Data Validation:

Data... > Validation... > Custom > Formula > =len(A1)=8
--
Gary''s Student - gsnu201002


"htown" wrote:

> I need to ensure each cell has 8 characters throughout a column .
From: Don Guillett on 6 May 2010 09:11

You are very UN clear about your need so I'll guess it's numbers and you
want to custom format
00000000
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"htown" <htown(a)discussions.microsoft.com> wrote in message
news:ED81F5A8-6DA2-48DA-9E10-495ED5ED0C62(a)microsoft.com...
>I need to ensure each cell has 8 characters throughout a column .

 | 
Pages: 1
Prev: Convert Date string to date format
Next: Count of numerical values within a cell