Userform currency issue only on one row advice

[ipbr21054]

Morning,
I understand this might not help without supplying you code etc but not sure what to supply.

I have a worksheet which column O is a value & formatted as currency.
First row is 6 & the cell shows example 65.00

I open my userform where all the text boxes pull the information from each cell on the worksheet.

This is my issue, row 6 column O shows 65.00 "CUSTOMER A" so when i open my userform i expect to see in the textbox in question 65.00 BUT i only see 65
Looking at the code i see nothing for which might only format say row 7 onwards thus row 6 not applied correctly.

As a test i added a new row on the worksheet so now the test is row 6 "CUSTOMER B"and in column O ive entered 99.00
I open the userform but i only see 99 for CUSTOMER B
BUT if i then look at CUSTOMER A it now show 65.00

Delete CUSTOMER B on the worksheet so now CUSTOMER A is at row 6 again & userform shows 65 again & not 65.00

So my issue is row 6 but checking all the code i cant find anything that might not include row 6

Any advice for how i can fix this.
Many Thanks

 

[ipbr21054]

here is the file to look at.

DOWNLOAD TEST FILE HERE

Double click CUSTOMER 001 then look in paid you will see 65
Then add new row on worksheet.
Open userform to see this new entry doesnt show the .00 at the end.
Now look at CUSTOMER 001 to see it now correctly shows 65.00
Delete your new customer from worksheet then look at CUSTOMER 001 on userform to see it now shows 65 again

Thanks

 

[ipbr21054]

Just an update.
The code below was removed & all my figures had the .00 removed.
Put the code back & the .00 was replaced.
All apsrt from row 6

Can you advise what this code please / where from

Thanks

Private Sub ComboBoxCustomersNames_Change()
        If Not EventsEnable Then Exit Sub
'get record
    R = Me.ComboBoxCustomersNames.ListIndex + startRow - 1
    Navigate Direction:=1
End Sub