Hi

I am importing data into my worksheet with Winshuttle & I want to limit all cells to showing either numbers without decimal values, or numbers as text.

I cant stop the import of data from changing my cell formatting from 0 decimal points or text-as-number.
Any thoughts how to set those preferences & then lock the sheet so it cant reset them back to numbers upon import of data that does have decimal values ?

I've tried the advanced options as well as highlighting 'all cells', then using the format cells option to limit to zero decimal places.

Thanks
Mike