I want to enter 16 digits and have it display as
xxxx xxxx xxxx xxxx
so I set Custom format as 0000 0000 0000 0000 and also tried
#### #### #### ####. Both work as far as the spacing of the displayed number but something is causing the rightmost digit to change to a zero no matter what I enter.
For example, 1234567812345678 displays as
1234 5678 1234 5670
What gives?
xxxx xxxx xxxx xxxx
so I set Custom format as 0000 0000 0000 0000 and also tried
#### #### #### ####. Both work as far as the spacing of the displayed number but something is causing the rightmost digit to change to a zero no matter what I enter.
For example, 1234567812345678 displays as
1234 5678 1234 5670
What gives?