View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clare Clare is offline
external usenet poster
 
Posts: 32
Default InsertNameDefine

I have a spreadsheet that has a list of employees names in column A. I use
F5 €śGo To€ť to locate an individual by name. I would like to leave the name
in the cell, but I would like to locate the individual by their Employee ID
number. When I try to name the cell with a number I receive an error €śThat
name is not valid€ť. Can I not use numeric instead of alpha for a name?