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
Remove decimal separator in number
-
- Posts: 2
- Joined: Tue Jul 21, 2020 2:46 am
Remove decimal separator in number
Last edited by MrProgrammer on Tue Jul 21, 2020 10:12 pm, edited 3 times in total.
Reason: Attached image, since the link will break; Changed subject, was: remove dot in number
Reason: Attached image, since the link will break; Changed subject, was: remove dot in number
openoffice 4.17 on windodws 7 64 bit
Re: remove dot in number
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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: remove dot in number
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
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.
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
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
-
- Posts: 2
- Joined: Tue Jul 21, 2020 2:46 am
Re: remove dot in number
I was trying to subtract the open price from the close price cell in their. so i can see the difference in pips.
openoffice 4.17 on windodws 7 64 bit
Re: remove dot in number
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
Does that work for you?
Code: Select all
=(F4 - C4) * 10000
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.