Page 1 of 1

Remove decimal separator in number

Posted: Tue Jul 21, 2020 2:55 am
by elliot_123
I searched but cannot find how to remove a dot in a number so it posts in as 114500 for example instead of 1.14500 for eurusd pair. I went into formatting but cannot figure out how to tell it to remove the dot in the middle

https://ibb.co/vVkzgf1
eurusd-pair.jpg

Re: remove dot in number

Posted: Tue Jul 21, 2020 4:15 am
by FJCC
You seem to be using a US locale, so you cannot remove the dot without changing the value in the cell. Multiplying the cell by 100000 will achieve the same thing. If multiplying by 100000 is not acceptable, please explain why you want to remove the decimal separator.

Re: remove dot in number

Posted: Tue Jul 21, 2020 4:19 am
by RusselB
Welcome to the Forums.
Having the decimal in the correct location is necessary for any calculations done with that number.
The only option I can think of, but do not recommend as you are changing the actual value, rather than just the display, is to use a helper column with a formula like

Code: Select all

=B2*10^5
This will give you, in the helper column, the number you are asking to display, but, again, I warn you not to do this, as you can easily get incorrect results by using the wrong cell address in other calculations.

Re: remove dot in number

Posted: Tue Jul 21, 2020 5:17 am
by elliot_123
I was trying to subtract the open price from the close price cell in their. so i can see the difference in pips.

Re: remove dot in number

Posted: Tue Jul 21, 2020 5:37 am
by FJCC
A pip seems to be 0.0001 in the context of euro dollar trading, judging from a quick internet search. If that is right, you can get the difference in pips by doing the subtraction of the existing numbers and multiplying the result by 10000. I cannot see which column has the closing price but let's say it is column F. The formula in row 4 would then be

Code: Select all

=(F4 - C4) * 10000
Does that work for you?

Re: Remove decimal separator in number

Posted: Wed Jul 22, 2020 12:26 pm
by keme