Using decimals in text?

  • Thread starter Thread starter Zerex71
  • Start date Start date
Z

Zerex71

Here's another question: Is it possible to change a line of text
depending on the value contained in a cell? For example, if I have a
decimal which is used as an exponent, can I concatenate that value with
a units string?

Example: value = 0.333, units = "kg" => "kg^0.333" (^ = font
superscript)
Now change the value to 0.396 and the units label should read
"kg^0.396".
 
use ="kg^"&A1 where A1 is the cell containing the decimal exponent. If
you want to be able to change the units, use =B1&"^"&A1 where B1 is the
cell containing the units.
 
Back
Top