what is in the original cell?
what exactly is displaying in the cell referencing it?
have you checked the cell's format and set it to the one you want?

Maybe post a workbook, so we can have a look at the actual data?