Is there a way by use of formula or VBA to copy and paste a value which is custom formatted to another cell.
I do not want to copy the formatting across to the new cell but I do want to display the whole string.
i.e. Cell A1 contains a number 001, which when entered changes to Final Review-001 using custom cell formatting.
If I copy and paste or paste special, I still get 001 including the formatting and cannot fathom how to paste as Final Review-001