OK... I figured out the number part of it through Data Validation, so now I just need to protect the cell, so they can enter a value, but not delete the formatting... it still removes it if you hit backspace or delete.

Well, I have columns for prepress, wide format, scanning, press time and bindery. The formula in the final cell is the total hours. That one is locked and cannot be changed. In the other columns, I want the operator to enter their time in a XX.XX formatting. Right now if someone enters an "f" the cell accepts that (although in the total column I get an ERR, which is what should happen), and it displays as, "f." If you hit delete, it erases the formatting and formula.

I want to force that cell to display an ERR if anything other than a number is entered. And I want it to convert the number to a decimal (if they enter 5, I want it to display 5.00). I have 90% of it formatted correctly - just need to make it so you can only enter a number and can't delete the formatting. I have it currently defined as a number, but it's not working (see screenshots), and if you delete out the f, it blanks out the formatting.

Quote from: DigiCorn on April 19, 2024, 09:15:02 AMI have a spreadsheet I'm creating in Excel to track jobs through the shop. In it I have some formulas to math for me. Problem is, it's really easy to accidentally delete or erase the formula and screw up the cell, so is there a way (without locking or requiring a password) to protect the formula inside that cell so it doesn't lose it's format and can still be typed in to? I know how to lock it, but then you can't add any new information, and the only other trick I know requires a password every time you want to add new information. Also, without the use of a 3rd party plug-in, is there a way to make a cell have a date finder calendar?

Why would anyone need to type into the cell that has the formula? If they need to change the data they should change the values of the cell the formula is based upon.

Well, I don't want a cell to be uneditable, but I do. I have a formula in the cell that does a math problem. I want the user to be forced to enter a number (not a letter - I want it to return an error), but not be able to edit or delete the math formula.

Can you rt. click the formula cell / format / lock
but then don't protect the whole sheet?
This does not require a PW until you want to unlock the cell.
HTH but I am no xls power user so

I thought you could lock cells without requiring a password.

QuoteLocking cells in Excel makes them non-editable by default. First, make sure the cells are unlocked by checking them under the Format cells menu. Then select the cell/range of cells you want to lock, locking them again under the format cells menu.
Enforce this by protecting the worksheet. Your select cells are non-editable now, without a password.

I have a spreadsheet I'm creating in Excel to track jobs through the shop. In it I have some formulas to math for me. Problem is, it's really easy to accidentally delete or erase the formula and screw up the cell, so is there a way (without locking or requiring a password) to protect the formula inside that cell so it doesn't lose it's format and can still be typed in to? I know how to lock it, but then you can't add any new information, and the only other trick I know requires a password every time you want to add new information. Also, without the use of a 3rd party plug-in, is there a way to make a cell have a date finder calendar?

Nothing involving Vecna, but I've heard reports of sightings of Pinhead in Finishing, but that's been going on forever. Other than that Corn has it down.

Also, I've been told it's much less of a problem on the Indigo 7R. Still happens sometimes, but much much less often. No reports of it happening on the Ricoh or Oce BW machines.

I'm still waiting for him to run the test file I created from a job that went fine for J. We'll find out if he ever did it when he gets in in a bit.

The 3 prepress operators should switch computers for a week and see if the problem follows the operator or stays with the computer. That could point to a software setting somewhere. 

So I just want to clarify:

J imposes a file in the QI plugin in Acrobat. J saves it to your server directory. The Digital Press Operator opens his RIP and navigates in the software to J's file and clicks, import, and it's right side up, peachy and smelling like a rose.

You impose the same file the same way in the QI plugin in Acrobat. You save it to your server directory. The Digital Press Operator opens his RIP and navigates in the software to your file and clicks, import, and it's upside down?

Have you seen any demogorgons or made an offering to Vecna?