puling a specific price from a list in single cell

[Phill032]

Hi guys,

Hoping someone can help with the below problem
I have a used car stocklist with the price changes made on the internet in the below format, each price is seperated by a "."
What i need is to pull the second last price change.

So my data in column O is - 0. 1099800. 788800. 777700. 699800 - the 0 at the front is the first listing and the are no seperators for cents.
The first actual price is 10,998.00, i just want to pull 7,777.00 being the second last price change.

 

[Phill032]

Hey Hey the *0.01 works a treat.
Thanks, i appreciate your help on this.

 

[dave2018]

My pleasure! Although I probably learned as much as you today