Hi all, our part numbers are entered onto Excel, and the cells are formatted as "text" in order to keep the part numbers in their original format.
Which is great, until we run a macro and the parts lose their formatting and return to
Examples
000456 becomes 456
1.10000 becomes 1.1
I sort of understand the "why" of why it's doing it, but more importantly don't want it to happen as in our industry the:
"456" relates to a plug and the "000456" relates to a bolt.
"1.10000" is a connector and the "1.1" is ermmmm gibberish.
The ways around it that we have thought of are to put a "_" at the beginning or end of each entry.
BUT that messes up other reports that we have going on, especially when we are merging data together.
Have you maybe come across this problem? and have you found a way around it?
Best
Neil
Which is great, until we run a macro and the parts lose their formatting and return to
Examples
000456 becomes 456
1.10000 becomes 1.1
I sort of understand the "why" of why it's doing it, but more importantly don't want it to happen as in our industry the:
"456" relates to a plug and the "000456" relates to a bolt.
"1.10000" is a connector and the "1.1" is ermmmm gibberish.
The ways around it that we have thought of are to put a "_" at the beginning or end of each entry.
BUT that messes up other reports that we have going on, especially when we are merging data together.
Have you maybe come across this problem? and have you found a way around it?
Best
Neil