flipatibm
02-11-2007, 08:33 PM
:help
I have product id's that in one instance, I'm just moving from one sheet to another and no conversion to scientific notation occurs. Product ID example: 5565E23. When I subsequently read that product id into a string array from a sheet and then, after some work, place it on another sheet, it gets converted to scientific notation. The destination cell is formated as text. I just want it to come out as it went in; 5565E23.
Any help is appreciated.
I have product id's that in one instance, I'm just moving from one sheet to another and no conversion to scientific notation occurs. Product ID example: 5565E23. When I subsequently read that product id into a string array from a sheet and then, after some work, place it on another sheet, it gets converted to scientific notation. The destination cell is formated as text. I just want it to come out as it went in; 5565E23.
Any help is appreciated.