Latest Contributions by BenjaminPezzillo

Try converting Column A to Text before you Copy and Paste Special/Values Only? Below: Columns A/B/C -- all had the same six keystroke input but three different encodings at input Columns D/E/F -- all copy and pasted special values only from A/B/C respectively, leading zeros as text preserved ... View more

Did you copy the data column and then "Paste Special" with "Values Only" selected?  That gets the formulas out of the data. Then you might want to check the data type setting for the column. After adding the Leading Zeros and Paste Special, you might want to change the data type to Text. That should lock in the changes you want in the table before you save it and import it ... View more

FLOATING RECTANGLE Any solution(s) to generate the largest 'floating' rectangle -- i.e. a shape that does not have a point(s) on the polygon? ... View more