Ask Your Question

MrGeminus's profile - activity

2017-05-06 10:34:01 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

Hi man, The first thing I tried was to make the column wider, but this doesn't worked out. The EAN remained in this stu

2017-05-06 10:34:01 +0200 received badge  Commentator
2017-05-04 07:55:57 +0200 received badge  Notable Question (source)
2017-05-03 20:31:32 +0200 received badge  Popular Question (source)
2017-05-03 17:10:55 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

Yeah, I have done that the first time, I selected in the drop down many column type the option text, but it doesn't chan

2017-05-03 17:10:49 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

Yeah, I have done that the first time, I selected in the drop down many column type the option text, but it doesn't chan

2017-05-03 17:09:40 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

Yeah, I have done that the first time, I selected in the drop down many column type the option text, but it doesn't chan

2017-05-03 16:57:55 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

I can't share these information with third parties. Sorry.

2017-05-03 16:47:29 +0200 commented answer Number in scientific notation instead of EAN (GTIN) code

Tried, nothing changed.

2017-05-03 16:40:31 +0200 commented question Number in scientific notation instead of EAN (GTIN) code

Hi Librebel, Tried it right now but it shows me 3528700000000 for all articles and the EAN can't be the same for all of

2017-05-03 16:33:04 +0200 commented question Number in scientific notation instead of EAN (GTIN) code

I have given an example, how can 3,53E+12 be connected to Egyptian Association of Neonatology for example? But anyway, y

2017-05-03 16:25:42 +0200 commented question Number in scientific notation instead of EAN (GTIN) code

I trough everybody knows that. EAN is short from European Article Number. It consists of 13 digits.

2017-05-03 16:17:22 +0200 commented question Number in scientific notation instead of EAN (GTIN) code

I trough everybody know that. EAN is short from European Article Number. It consists of 13 digits.

2017-05-03 16:06:13 +0200 commented answer Decimal numbers

Hi man, I have to use point decimal separator. Regarding the second part, yes, I have to change a lot of cells value and

2017-05-03 15:51:03 +0200 commented answer Decimal numbers

I am not sure if I understood you correctly. I must use "." for the decimal numbers (see my comment above). These decima

2017-05-03 15:46:47 +0200 commented answer Decimal numbers

Hi man, It's not so easy :D The problem is that I can't use ",", because our system doesn't recognize it like decimal nu

2017-05-03 15:39:10 +0200 received badge  Notable Question (source)
2017-05-03 15:37:59 +0200 asked a question Number in scientific notation instead of EAN (GTIN) code

Scientific notation Hi guys, I got I csv file with EAN-s. The problem is that the EAN-s are displayed in calc as scien

2017-01-12 17:03:36 +0200 received badge  Famous Question (source)
2017-01-07 17:20:13 +0200 received badge  Notable Question (source)
2017-01-07 17:01:21 +0200 received badge  Popular Question (source)
2017-01-07 15:59:38 +0200 received badge  Popular Question (source)
2017-01-05 11:41:32 +0200 asked a question Decimal numbers

Hi all again,

Does somebody have an idea how to make from for example 34567 the decimal number 34,57 in calc?

Thanks! :)

2017-01-03 15:46:12 +0200 answered a question Compare two prices and display the difference in % in new column

Yeah, but I trough there is maybe a faster way to do that, with some formula, which would calculate automatically the difference and mark these prices in red. I mean, it would be great to have something like that for the finance purposes.

Anyway, thanks! :)

2017-01-03 14:57:16 +0200 asked a question Compare two prices and display the difference in % in new column

Hi,

My problem is the following: If I have for example in column A old prices and in column B new prices and I want to see are there any price changes and if yes, how much is exactly the difference between these old and new prices in %, which would be shown in a new column C for example, what is the best way to do that?

And also, if I could mark in column B with some color (for example red) the new prices which differ from old prices more then 30%, that would be great for easy spotting in a huge list.

Thanks in advance!

Cheers!