Need help removing tooltip or smart tag

[Jayfaas]

We have a protected sheet at work with locked cells and data entry cells. When you click on a data entry cell, a box pops up that says "Data entry cell Enter only numeric value". How do I get rid of this box? It because a pain in the butt when you are trying to view other cells all at one time and the box is covering the cells.

[6StringJazzer]

It is almost certainly a Data Validation prompt. If it's in your way, you can simply click on it and drag it around to move it.

To eliminate it, select the cell and go to Data, Data Validation, Input Message tab, and uncheck "Show input message when cell is selected".

However, if the sheet is protected you probably don't have permission to do this.

If it is not a Data Validation prompt then it is probably a macro.

[Jayfaas]

That helped big time. Thank you for that. One more thing I would like to ask is how do I get cells to show decimals without affecting data validation or formulas? For this particular sheet, it should be 3 decimals (0.060) but it cuts off the last zero and then doesn't follow the same format. I need it to show what is entered so its uniform, but it cant just be set to 3 decimals because some others we use whole numbers and some we use 2 decimals. Any ideas? The data validation is set to allow decimal between a certain min and max (which is fine) but it auto formats it. If I try to change the fields to "text", it affects the data validation because its not a "numeric value". Any ideas?

[6StringJazzer]

I'm not following how these two statements fit together:

it should be 3 decimals (0.060)

it cant just be set to 3 decimals because some others we use whole numbers and some we use 2 decimals.

So when should it be 3 decimals, when should it be whole numbers, when should it be 2 decimals?

What do the formulas in those cells look like?

[Jayfaas]

So I entered .060 and it puts in .06. It removes the last zero. I would like the last digit (if 0) to stay. Also...this is a template spreadsheet. Some of our readings are whole numbers, some are 2 decimal, some are 3, etc. It all depends on the equipment on which we are performing the study. One of the fields calculates the X bar which the formula looks like this: =IF(COUNT(C9:E9)>1,AVERAGE(C9:E9),AC9). The other calculates the range which looks like this: =IF(COUNT(C9:E9)>1,((MAX(C9:E9))-(MIN(C9:E9))),AI9). As far as the data entry fields, they have no formulas. However, something is tied in because if I try to remove the data validation or change it to text, the formula fields no longer pick it up. Im guessing it cant calculate if its not a "number"?

[6StringJazzer]

Are you saying that when you type in a number, you want the displayed precision to be preserved according to what you typed? That is,

You type 0.060 hit ENTER and see 0.060
You type 0.06 hit ENTER and see 0.06

That is an interesting question. I do not know of a way to do this other than by using a macro and using form to enter the data so the code can know exactly what was typed in. Simple example attached. This example assumes there will be at least 1 digit after the decimal, but it's just an example and could be made more sophisticated.

You are right, in general you can't do much calculation with numbers that are entered as text.