Re: Formatting SI units in Excel

On Thu, 01 Mar 2007 08:57:11 +0100, Jeroen Belleman wrote:
Homer J Simpson wrote:
"WAYNEL" <home@xxxxxxxxxxxxx> wrote in message
news:1172609151.797275.140820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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

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.

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

Good Luck
Rich

.

Quantcast