Seba Robles
Board Regular
- Joined
- May 16, 2018
- Messages
- 71
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello,
I have a macro that is copying data from one workbook to another and everything is working as it's supposed to.
However, there are some number values from the original source (from where I copy) that have leading zeroes and when the macro pastes that into the new workbook, the values are pasted without the leading zeroes.
If I do the copy paste manually, I do not loose the leading zeroes and the values are pasted as text (which is what I want). But when the macro does the same thing, it doesn't keep the values as text and it removes the leading zeroes.
Additional info: I only need two columns from the original source to be kept as text after pasting into the new workbook.
Do you know if there's a way around this in VBA?
Let me know if you need any additional information.
Thanks in advance!
I have a macro that is copying data from one workbook to another and everything is working as it's supposed to.
However, there are some number values from the original source (from where I copy) that have leading zeroes and when the macro pastes that into the new workbook, the values are pasted without the leading zeroes.
If I do the copy paste manually, I do not loose the leading zeroes and the values are pasted as text (which is what I want). But when the macro does the same thing, it doesn't keep the values as text and it removes the leading zeroes.
Additional info: I only need two columns from the original source to be kept as text after pasting into the new workbook.
Do you know if there's a way around this in VBA?
Let me know if you need any additional information.
Thanks in advance!