Range Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am used to using Lotus 123 and in that i could name a cell or range of
cells with a number like 101 , if i try this in Excel i get and invalid name
message come up, is it not possable to give a cell or range of cells a number
as a name ??
 
Stan Halls said:
I am used to using Lotus 123 and in that i could name a cell or range of
cells with a number like 101 , if i try this in Excel i get and invalid
name
message come up, is it not possable to give a cell or range of cells a
number
as a name ??
Click to expand...

No, because otherwise Excel wouldn't know whether to use the name or the
number, but you can use things like underscores in names, so _101 would be
legal.
 
David
Thanks for that

David Biddulph said:
No, because otherwise Excel wouldn't know whether to use the name or the
number, but you can use things like underscores in names, so _101 would be
legal.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Xindex 2
Set non-continuous PrintArea via Function / Name 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Constructing Range Name calls with Concatenate 4
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
How do I have a cell value define a dynamic named range? 15
A find formul looking at two named ranges for two strings 6

Back
Top