Thread: How to change the decimal format to keep what you type in.

If you right click on a cell and bring up "Format Cells" and select the number tab; I want the format of the cell to act just like the "Text" option but conditional formatting needs to still work.

In other words when I type in "1.000" in the cell, I want it to read exactly that. If I try to use the "General" format it defaults the cell to "1". I have tried using the "Number" category but I sometimes have numbers such as "1.0" that I don't want to read 1.000 (or whatever I would specify (0.000, 0.0000)

Let me know if this is enough information to answer on.. Thanks!

Change the formatting to text. In the conditional format formula, add 0 to the cell, such as =A1+0=1.

Well ok.. That seems to work easy enough..

Thanks for the help.. Here is an example of my conditional formulas..

Code:

=OR(Q11=0,AND(J11+0>=U11,J11+0<=T11))

=OR(J11+0>T11,J11+0<U11)