Forum Discussion

Copper Contributor

Oct 21, 2020

Excel function TEXT with custom number format using "."

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 (als...

excel

Formulas and Functions

NikolinoDE

Gold Contributor

Oct 21, 2020

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-us&rs=en-us&ad=us

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.

AndrzejuZ
Copper Contributor
Oct 21, 2020
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.