Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation rule - force text entries to appear as Proper
Is there a way to force text entries using Data validation such that any
entries will appear in the Proper format? test = Test Test= Test Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation rule - force text entries to appear as Proper
A couple of ideas. You can either use data validation to warn them
that the first word is not proper or you can always force it to be proper using VBA. With VBA: Put this in the worksheet module of the sheet you are affecting: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Target.Value = Application.WorksheetFunction.Proper(Target.Value) ErrorHandler: End Sub Or with data validation use custom and then put this formula in: =and(Code(A1)=65, Code(A1)<=90) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
Validation rule | Excel Discussion (Misc queries) | |||
Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
How to force a wrap text function when the cell is big enough to p | Excel Discussion (Misc queries) | |||
How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) |