Copy paste custom formatting

  • Hi All,

    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


  • You can do a direct assignment using code like:

    Range("B1").value = Range("A1").Text

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!