XL2016 64 bit
I have an Excel table with a column of numbers formatted as text 000502 (the results of a SQL query)
I am looping through the Table rows and splitting the data into multiple rows as required.
Using
The new rows cell content is 502 as a number not 000502 as text.Please Login or Register to view this content.
HOW CAN I RETAIN THE VALUE AS A TEXT ENTRY OF 000502
Formatting the Table column does nothing.
Using Text to Columns on the Table column does nothing.
Bookmarks