An easier way to do this: Go to File > Options > Advanced > Uncheck system separators > Set dot as a decimal separator and set a comma as thousands separator > Click ok

@computertutoring

4 жыл бұрын

Darius Torres thanks for your input really appreciated, make sure you check out our other tutorials with yet more solutions to this problem including the one below. Take care my friend

@sezerturk5637

4 жыл бұрын

thank you

Thats very clever thank you man

A very long and manual solution for a simple thing. Just use numbervalue formula and fix this in one second.

@computertutoring

6 жыл бұрын

Thanks for the advice I'll check out number value

@kokokingsley8491

6 жыл бұрын

God bless u

@sezerturk5637

4 жыл бұрын

thank you

Not working at excell 2007.. Why?