flyers2thecup
Active Member
- Joined
- Jul 29, 2004
- Messages
- 362
I have a payment request spreadsheet that goes out to different business lines. On this form, are people who are getting incentive awards. I have to take the awards and save as .csv files and load the awards into peoplesoft. Some of the awards are based on sales. Therefore, some of the business lines use their own formulas to derive the amount that goes onto my template. But I need the awards to stay two decimal places. They are cutting and pasting and I get numbers like 1244.4596825. Is there a way to make a message popup to say, "The amount you are trying to paste is more than two decimal places. Please correct and enter a valid number."
Also, is there a way to lock just a CELL? not the sheet. I need them to be able to enter info...but some people change my formulas and it makes me very angry!!!
Thanks in advance!!!
Also, is there a way to lock just a CELL? not the sheet. I need them to be able to enter info...but some people change my formulas and it makes me very angry!!!
Thanks in advance!!!