Thread: excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB
 
Posts: n/a
Default excel

Have you Tried Data Validation (Data/Validation - select whole number,
minimum of zero)

You could also format the cell to show dashes with Format/Cells/Special - SSN.

"Renetta" wrote:

hi,

I need to limit what is entered into a specific column associated with
ssn's. Specifically, I do not want someone to enter dashes or add spaces.
Reason is formating purposes assocated with linking information into Access.