Changing the Number Format

[Yohnson]

Hello Friends,

I have a quick question about Formating Excel Numbers.

My numbers are like 11.234,45 and I want to change that into 11,23 for example.
So that it changes to thousands instead of the entire number.

Thank you very much in avance!!!

[Sam Capricci]

maybe this... =LEFT(SUBSTITUTE(A1,".",","),5) assumes it is in A1.

[MrShorty]

I'm not exactly sure how it works when "." is the thousands separator and "," is the decimal separator, but (with my regional settings "," is thousands and "." is decimal), I can use "," to "scale" numbers by a thousand. So, a number format code of "0.00," will display 11234.45 as 11.23 (meaning 11.23 thousand). The underlying value of the cell is still 11234.45, but the display is 11.23 (which sometimes causes confusion).

You might review this helpfile (one that I referred to frequently when learning spreadsheets) https://support.microsoft.com/en-us/...7-9c9354dd99f5 perhaps find the same page in your installations help files, in case MSFT has a copy that explain how the guidelines apply to different region/language settings.

[Yohnson]

Thank you so much!!

I found the correct format by accident. I can just use "0,00." to format it.