Text to Number

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
 
N

Nicky

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.
 
E

Eric van Uden

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.
 

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