Remove decimal separator in number

[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

[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.

[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.

[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.

[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?

[keme]

See also
viewtopic.php?f=9&t=93565
and
viewtopic.php?f=9&t=66552