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?

InsertNameDefine
 

Enter/name it with a preceding underscore, eg: _1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Clare" wrote:
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?

InsertNameDefine
 

Nope.

maybe you could lead with an undersco
_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.

Clare wrote:

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?

--

Dave Peterson

InsertNameDefine
 

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

"Clare" wrote:

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?

InsertNameDefine
 

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.

--
Cheers,
Shane Devenshire


"Clare" wrote:

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?

InsertNameDefine
 

Thanks to all. That works great!

"ShaneDevenshire" wrote:

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.

--
Cheers,
Shane Devenshire


"Clare" wrote:

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?