Custom Number Format

D

dave

I would like to be able to create a format for "millage"
rates (used in calculating taxes).

For example I would like to have the numeric value .00551
appear as 5.51m, five point five one mills. (In truth I
would really like to be able to use the proper symbol for
the value, 0/00, but similar to the % sign, i.e. with two
zeros in the denominator but I'd settle for using the "m"
to designate mills.)

Thanks for any and all help,

dave
 
D

Dave Peterson

Maybe a custom format:

0.0\m

But if you're using the Arial font, this might be what you really want.

use a custom format of
0.0\(alt-0137)
hold alt and type 0137 from the number pad--not above the QWERTY keys. (Don't
type the parentheses.)

I'm not sure how many different fonts support this, but you can check it by:

Windows Start button|Run|Charmap

(That's how I found it.)
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top