fixed length, zero fill cells

[gumperefo]

I need take a dollar amount (50.00) and turn it into an 11-character fixed length cell w/o the decimal (00000005000).

Any recommendations would be appreciated.

 

[Mark W.]

=RIGHT("00000000000"&DOLLAR(A1)*100,11)
=RIGHT("00000000000"&TEXT(A1,"0.00")*100,11)
=SUBSTITUTE(TEXT(A14,"000000000.00"),".","")

...take your pick.
This message was edited by Mark W. on 2002-10-10 15:05