Name a cell as a number in Excel

D

DanH

Why does Excel only let me name a cell with an alpha name and not a numeric
name?
I need to create a spreadsheet that logs the number of gallons of fluid left
in a round tank via sight glass or by sticking the tank.

Gallons are known and constant by 1/4", 1/2", 3/4" and full inches.

Example:
15" = 1166 Gallons
15.25" = 1195.5 Gallons
15.50" = 1225 Gallons
15.75" = 1254.5 Gallons

I want to be able to put 1166 in a cell AA1 and name it 15 and be able to
put =15 in cell A1 and Excel put 1166 in that cell.
 
J

Jim Thomlinson

It would be a problem becuase Excel would not know how to interpret this
formula...

=A2 + 15

Do you want to add the value 1166 or the value 15 to the contents of Cell
A2. Excel would have no way of knowing what you meant. You could do "_15"
which Excel can interpret...
 

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

Top