Excel function TEXT with custom number format using "."

[AndrzejuZ]

Hi,

I am trying to use formula like =TEXT(value;"000000000000.00") and it properly works in my EXCEL 2016 the value of 12345 is presented as 123.45  but do not work in my customer's environment (also 2016) there is na #ARG! error. Point as a coma separator is not allowed there. In fact in my environment it is not treated as a coma separator --> 12345 is presented as 123.45. I have checked many settings (region, language, numbers format...) It is the same, so what determines acceptable custom number formats?

[#2]

@AndrzejuZ 

= TEXT (1234, "0000000")

Adding leading zeros (0), e.g. B. 0001234

TEXT function

https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c?ui=en-...

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NikolinoDE 

Thanks for quick response.

I know this support information, but it doesn't help in this case

I need to set format "000000000000.00" so for amount 12345,67 I need text 000000012345.67

It means leading zeros and point instead of coma. This format is available in my Excel but not available in another environment so I asked which excel or windows settings determine formats availability?

At the moment I did a workaround by dividing the amount and joining separate texts. It works but I just wonder how it happens.