Connect with us

Formatting SI units in Excel

Discussion in 'Electronic Design' started by WAYNEL, Feb 27, 2007.

Scroll to continue with content

    WAYNEL Guest

    Does anyone know of a method or add-on for SI formatting SI units in

  2. Hello WayneL,

    are you talking about SI-units like m, kg, s or do you think on the
    SI-prefixes p, n, u, m, k, ... which are numeric multipliers.

    Best regards,
  3. Several examples would help.



  4. Wouldn't it be nice if Excel could display '1n', instead of '1.00E-9' or
    worse '0.000000001'? And it would be great if I could type 4M7 and have
    it interpreted as 4.7 million.

    I'm surprised this is so rarely done. It not hard or anything. I only
    know of gnuplot and spice that use some of this, and spice even gets it
    wrong, confusing M(ega) and m(illi). Pathetic.

    Jeroen Belleman
  5. IMO it would be reasonably easy to do in VBA.
  6. Rich Grise

    Rich Grise Guest

    Does excel support "custom" formats? You could write a little parser in
    VBA, but I don't know of anything OTS.

    Good Luck

    WAYNEL Guest

  8. Jim Thompson

    Jim Thompson Guest

    All the PSpice utilities my oldest son wrote for me can accept entries
    like "8.46p" etc.

    I believe it can be done in Excel as well, but I couldn't find it.

    Mark/qrk, Didn't you show me how to do that once? Or was it someone

    ...Jim Thompson
  9. When you enter the field to update it you need to erase the contents. Then
    when you leave the field you parse the contents and rewrite as needed.
  10. John B

    John B Guest

    Errrrm. "Yes" to which part of the question?
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 (here). After that, you can post your question and our members will help you out.
Electronics Point Logo
Continue to site
Quote of the day