Name a cell as a number in Excel

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

Guest

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.
 
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...
 
Back
Top