Morning!
I'm experiencing a hard time trying to figure out a number format mask in Excel. The number format is quite simple: just numbers, dots and a hyphen. The format is: 0003475-09.2014.8.05.0001 (7 numbers, hyphen, 2 numbers, dot, 4 numbers, dot, 1 number, dot, 2 numbers, dot, 4 numbers).

I put the following mask in Excel:
0000000-00"."0000"."0"."00"."0000



Here is the trick: Excel put the number in the given mask, but it always changes the 2 last numbers to zeroes ("00").

E.g., if I feed the number 00034750920148059987, I get back the result 0003475-09.2014.8.05.9900. If I feed the number 00034750920148054567, the result is 0003475-09.2014.8.05.4500.

Can somebody help me, please?