Format Cell
 

I need to limit a cell to 30 digits.

Format Cell
 

Do you mean format, or did you intend to ask about data validation?
--
David Biddulph

"bennetto" wrote in message
...
I need to limit a cell to 30 digits.

Format Cell
 

hi,


Try

Data|Validation - Text length - less than or equal to - enter 30 - OK

Mike

"bennetto" wrote:

I need to limit a cell to 30 digits.

Format Cell
 

I guess I meant validation but I didn't know it. Mike H's answer worked.
Thank you both for your help!

"David Biddulph" wrote:

Do you mean format, or did you intend to ask about data validation?
--
David Biddulph

"bennetto" wrote in message
...
I need to limit a cell to 30 digits.

Format Cell
 

Thanks, Mike! I knew it was something simple. You made me look good...
Terri

"Mike H" wrote:

hi,


Try

Data|Validation - Text length - less than or equal to - enter 30 - OK

Mike

"bennetto" wrote:

I need to limit a cell to 30 digits.

Format Cell
 

Are you sure you're willing to put up with typing 31 letters and getting the
error message which tells you to do it all over again?

I would use event code which limits the text to 30 characters or less
without the annoying message DV provides.

Example code...................no error trapping for text or dates

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1:A10" 'edit to suit
Dim cell As Range
On Error GoTo ws_exit:
Application.EnableEvents = False

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If Len(.Value) 30 Then
.Value = Left(.Value, 30)
End If
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 12 May 2009 11:57:01 -0700, bennetto
wrote:

Thanks, Mike! I knew it was something simple. You made me look good...
Terri

"Mike H" wrote:

hi,


Try

Data|Validation - Text length - less than or equal to - enter 30 - OK

Mike

"bennetto" wrote:

I need to limit a cell to 30 digits.