As Peo said, this can't be done via formatting. You can use a rather
complex formula to acheive the result though. The formula below is
assuming that the current value is in cell C2:
=IF(ISERROR(FIND(".",C2,1)),TEXT(C2,"00000000")&"0 0",IF(FIND(".",C2,1)+1=LEN(C2),TEXT(C2,"000000000" )&MID(C2,FIND(".",C2,1)+1,1)
& "0",TEXT(SUBSTITUTE(C2,".",""),"0000000000")))
Carina wrote:
I want to to display numbers into 10 digits including cents but no decimial
point ".". For example: $0.01 display as 0000000001 or $100.00 display as
0000010000. Can some one help?