HI Johnny,
The reason I wanted to do this so that I can count number of total pips for
my Forex Journal.
The currency pair was not your normal decimal place. USD/JPY
Example: number of PIPs were 1.23 which is really 123 PIPs so I needed to
line up as 0.0123 to get total number of PIPs (Forex Market) As Tom's
solution was to divide the cell by 100 actually solved my problem.
Not your usual calculations.....
PIPS
EUR/GBP short $4,896.00 0.8750 0.8655 0.8650 0.0236
AUD/NZD short $5,050.00 1.2506 1.2343 1.2338 0.0080
USD/JPY short $5,022.00 77.22 76.31 76.26 1.23
cheers John.
--
View this message in context:
http://nabble.documentfoundation.org/Decimal-Point-Move-tp3260784p3266788.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted