Data Connection - rounding my numbers DOWN!!

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

You can use the equation below. You may need to add in the currency sign within the quotation marks.

Formula:

Please Login or Register  to view this content.

Hi Hoyasaxa,

I don't want to round up or down anything.

I just don't understand why excel's data connection is pulling my data across correctly.

Thanks
Carol

How do you transfer the data from the master sheet? If you can upload a sanitized workbook with an example or two, it'd be helpful in solving your problem.