Insert>Name>Define

[Clare]

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?

 

[Max]

Enter/name it with a preceding underscore, eg: _1

 

[Dave Peterson]

Nope.

maybe you could lead with an underscore:
_12345

======
It would be difficult for excel to know if you meant:
=12345+7
should be the value in that named cell or the real number 12345.

 

[FSt1]

hi
it's to my understanding that the nameing convictions for named ranges will
not take all numbers. but it will take numbers if you precede the number with
letter.
not sure if that will help you but it is a work around.
regards
FSt1

 

[ShaneDevenshire]

Hi,

Here are the rules for range names:

Start the name with either a letter or an underscore.

Names can contain letters, numbers, periods, and underscores.

Names can be up to 255 characters long.

Names can be in upper or lower case - they display in the case you define
them with.

Range names cannot contain spaces.

Range names cannot be cell addresses (for example A10).

The single characters C and R are not legal range names.

 

[Clare]

Thanks to all. That works great!

Hi,

Here are the rules for range names:

Start the name with either a letter or an underscore.

Names can contain letters, numbers, periods, and underscores.

Names can be up to 255 characters long.

Names can be in upper or lower case - they display in the case you define
them with.

Range names cannot contain spaces.

Range names cannot be cell addresses (for example A10).

The single characters C and R are not legal range names.