Hi, Please can some one help me.

Excel keeps rounding down my number when pulled through to another sheet via Data Connection.

EXAMPLE:

Workbook 1 / Sheet 1 = "Master Data" - this sheet is connected to a number of other Excel sheets.

On "Master Data", Cell D 12 = £4.3100. (White table on image)

When the data is transferred to another work book D12 becomes £4.3099 (Blue table on image) Other numbers seems to be fine. but not £1.1300 (it becomes £1.1299!!)

I tried various formatting options but it is not working. I have done format painting over those cells and still not working.

Please help!! excel.PNG