Custom Number Format

  • Thread starter Thread starter dave
  • Start date Start date
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
 
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.)
 
Back
Top