I want to format the number :
100007878
to be displayed like :
1 0000 7878
But when I put :
# #### ####
in Excel's formatting formula, I've got the following result :
100 007 878
I've searched this site, according to this, it should work. I find it odd.
How can I get the right display ?
