Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cell
I need to limit a cell to 30 digits.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |