Excel Format in K€ Solved

Question

Hello everyone,

I'm trying to create a custom number format in k€
For example: in one cell I have the number 1000 and I would like it to display as 1 k€
In another cell I have 1000000 and I would like it to display as 1 M€

It seems simple you might say, at least for the first example, you have to add a space before the quotes to divide by a thousand. Well, I’ve added spaces, but it adds spaces instead

I created the format:

# #.#0# " k€" is there an error? the division by 1000 isn't happening

Here’s the result: 1.000 k€

I’ve also created the format:

[>=1000000]0 "M€";[>=1000]0, "K€";0 € =
and also:

[>=1000000]0,,"M€";[>=1000]0,"K€";0 €

Here’s the result every time:
10000000,,M€
5000,K€
-$5000€
$500€

I would like it to display:
10 M€
5 k€
-5 k€
500 €

Is there an option that might not be active on my PC?

Configuration: Windows Vista Internet Explorer 7.0

tontong · Accepted Answer

Hello, Try this custom format [>=1000000]0.000000 "M€";[>=1000]0.000 "k€";0 € You can adjust the number of decimal places but you must keep 2 spaces before "M€" and 1 space before "k€"

Boz · Answer

Hello, if you are still working in K€, you can go to the control panel, regional and language options, customize this format tab, currency symbol tab, you replace € with K€. Boz

ella12_12 · Answer

Hello Tontong,  Here’s what it looks like: 1000,000 k€ I would like 1 k€ and I entered 1000 in the cell   A big thank you for your help  E

tontong · Answer

Hi, At my place, it shows €1,000k, there might be a problem with the regional settings. I have the comma as a decimal separator, is that the case for you?

ella12_12 · Answer

Hello Tontong,

I've checked the regional settings and yes, I do have the comma as the decimal separator. What’s strange is that no matter how many spaces I put before the quotation marks for "k€", it doesn't divide by a thousand

Thanks again for everything
E

eriiic · Answer

Good evening,

In principle, to divide by 1000 it's the,

Thousand separator To display a space as the thousand separator, insert a space in the number format. Likewise, to divide a number by a multiple of a thousand, insert a comma in the format. To display Use this code
12000 in the form of 12.000 #.###
12000 in the form of 12 #,
12200000 in the form of 12.2 0,0..

eric

qmike · Answer

Hello check this out, an example via a custom format Transform 50000 into 50 K€ http://mvergriete.club.fr/EXCEL/342excel.html have a nice day

Excel Format in K€

7 answers

Insufficient usb resources problems

Can we see the discussion block?

Incompatible display driver

Where are my smartphone backup data stored?

Trail camera requires a code

Convert video mov file

Dictation voice

Choose the format

Format choice

My posts are invisible for no apparent reason