how to prevent formats from changing?

[flyers2thecup]

I receive spreadsheets from business lines with information regarding bonuses. I then copy/paste some of the information into a .csv file to upload into our system.

Some of the business lines bonuses are sales and they use formulas to generate the amount of the bonus. In doing this, it's not odd to see a number with 10+ digits past the decimal place. This causes an error if uploaded. Not to mention, if they use comma separator for thousands.

My spreadsheet template has the correct format, but if they don't consiously COPY/PASTE SPECIAL/VALUES, then it changes the formatting to that of what is getting pasted.

Is there a way to prevent that from working?? or a pop up message or something?

In fact, I wouldn't want ANY formatting to change on the ENTIRE sheet. Is that feasable?

Thanks in advance!

 

[just_jon]

Did I not get back to you on this?

 

[flyers2thecup]

No. :wink: But i wasn't complaining about it. I was just going to try other options.

thanks!

 

[just_jon]

well then I've found the file -- I swear, never was your PM, so please PM me again with your email address and I'll ship this thing off.

 

[flyers2thecup]

PM sent. thanks.