Text to Number

  • Thread starter Thread starter MK
  • Start date Start date
M

MK

Is there a way to have text recognized as a number so the
text in that cell could be used in a formula? Example:
Buffing=0.75 Sweeping=0.5 Vacuum=0.25 So when the text
is entered in a cell, that cell reference could be used in
a formula with the assigned value.
Thanks
MK
 
It’s a bit complicated, but you can do it by setting the cell’s number
format to include the text you want to add. For example, click:

Format
Cells,
Number,
Custom
And type “Buffing = ”#,###.######## (with the quotation marks) into the
‘type’ box.

When you enter the number 6.6 in a cell with this format, it will
appear as Buffing = 6.6. The cell format is numeric, with the text
acting as formatting like the dollar signs in cells formatted as
currency. The hash marks after the point indicate the maximum number of
decimal places – add more if you’re using very small or precise
numbers.
 
Hello MK,

Could it be that you just mean this:

you type Buffing, Sweeping, Vacuum or one or two other names in one column.
Then in another column you would have a formula that results in (e.g.) a
numerical total?

If so, you might try something like this:
with your text in A1
in B1
=IF(A1="Buffing","0.75",IF(A1="Sweeping","0.5",IF(A1="Vacuum","0.25","")))
Fill down with this formula.
You can enter a number of these items in column A and the values will show
up in B.
Then you can total these amounts.
Or make a different use of this set of nested IF-statements.

Or did I misunderstand?

Have a fine day.
 
Back
Top