+ Reply to Thread
Results 1 to 2 of 2

Using decimals in text?

  1. #1
    Zerex71
    Guest

    Using decimals in text?

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


  2. #2
    Registered User
    Join Date
    05-23-2006
    Posts
    58

    try this

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1