Remove decimal separator in number

Discuss the spreadsheet application

Remove decimal separator in number

Postby elliot_123 » Tue Jul 21, 2020 2:55 am

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
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
openoffice 4.17 on windodws 7 64 bit
elliot_123
 
Posts: 2
Joined: Tue Jul 21, 2020 2:46 am

Re: remove dot in number

Postby FJCC » Tue Jul 21, 2020 4:15 am

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7970
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: remove dot in number

Postby RusselB » Tue Jul 21, 2020 4:19 am

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   Expand viewCollapse view
=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.
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.
User avatar
RusselB
Moderator
 
Posts: 6312
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: remove dot in number

Postby elliot_123 » Tue Jul 21, 2020 5:17 am

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
elliot_123
 
Posts: 2
Joined: Tue Jul 21, 2020 2:46 am

Re: remove dot in number

Postby FJCC » Tue Jul 21, 2020 5:37 am

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   Expand viewCollapse view
=(F4 - C4) * 10000

Does that work for you?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7970
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Remove decimal separator in number

Postby keme » Wed Jul 22, 2020 12:26 pm

User avatar
keme
Volunteer
 
Posts: 3402
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests