Maker Pro
Maker Pro

Formatting SI units in Excel

W

WAYNEL

Jan 1, 1970
0
Does anyone know of a method or add-on for SI formatting SI units in
Excel?

WayneL
 
H

Homer J Simpson

Jan 1, 1970
0
Does anyone know of a method or add-on for SI formatting SI units in
Excel?

Several examples would help.


--
..

--
..
..
..
..
..
..
..
..

--
 
J

Jeroen Belleman

Jan 1, 1970
0
Homer said:
Several examples would help.

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
 
H

Homer J Simpson

Jan 1, 1970
0
Jeroen Belleman said:
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.

IMO it would be reasonably easy to do in VBA.
 
R

Rich Grise

Jan 1, 1970
0
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.

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

Good Luck
Rich
 
J

Jim Thompson

Jan 1, 1970
0
Hi Helmut

Yes.

Regards

WayneL

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
else?

...Jim Thompson
 
H

Homer J Simpson

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

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