Can't display contents of another cell EXACTLY as they appear on original

I have a code that takes the data from a cell on one sheet and copies it to another cell on another sheet.

The original cell does have a formula that reads:
=IF(D4="Shuffle",D4,"$" & IF(E4="",TEXT(D4,"0.00"),D4 & " - "& E4))

I don't think the formula should matter though.

The contents of the cell display correctly on this sheet. For instance, one cell (L3) displays $20, which is how it CORRECTLY SHOULD LOOK.

I run a macro to take the data and display it in another cell on another sheet.

Please Login or Register  to view this content.

However, on the new sheet, the transfered cell now displays as "$30 - 0" instead of "$30"

I've tried modifying my code so instead of .value, it is .text or .value2 but couldn't get the cell to transfer correctly.

All cells are formatted with a GENERAL display.

Any idea how to make the destination cell read EXACTLY as the original?

I understand. I have been trying to create the issue on a sample workbook but cannot recreate the issue. When I copy just the pages I'm working with to another workbook and run the same code, I don't get the problem

I would send the original but it is so big and has so much confidential information, it would be so hard to just trim it.

Its so confusing. I guess I was hoping there was just some obvious issue I was missing. I will keep trying to duplicate the issue.

Thank you.

I found my problem. So if anyone has an issue like this again, here is the problem I had.

Elsewhere in my code I had this line:

Please Login or Register  to view this content.

I had turned it to Manual prior to running my codes with the intention of speeding up the process. However this is where the problem was, because as soon as I changed it to the below code, it all worked perfectly.

Please Login or Register  to view this content.

Thanks again for everyones help.