need to find with 1 decimal data.

[sksanjeev786]

Hi Team,

I have copied the below table from the PPT table so for few data decimal got miss with 0 so can I find where ever .0 is missed in the below table
Like in D1 and D2 it should be 3.60 and 6.6 but on the PPT table it is with 1 decimal so I wanted to know where it got missed in the table

book2
	A	B	C	D	E	F
1	4.11 BCD	3.56	3.69	3.6	3.74	3.76
2	4.82	5.12	5.41	6.6	6.48	5.91
3	4.46	4.34	4.57	4.56	4.36	4.55
4
5
6	-	-	-	3.47	3.28	3.52
7	3.43	3.19	3.21	3.13	3.33	3.48 D
8	3.40 C	3.16	3	3	3.03	3.33 C
9	35	37	48	30	39	52
10
11	3.41	3.58	2.73	3.4	3.19	3.14
12	2.64	2.42	2.36	2.53	2.55	2.45
13	3.42	3.23	3.16	3.2	3.2	3.04
14	4.30 B	3.96	4.14	4.27	4.18	4.35
15	2.82 C	2.48	2.32	3.19 A	3.01 B	2.92 C
16	4.02 BC	3.45	3.43	3.85	3.96 B	3.80 C
17	4.11 BCD	3.54	3.5	3.65	3.73	3.77
Sheet1

Thanks
Sanjeev

 

[C Moore]

Conditional format. =IF(LEN(cell)<4,TRUE,FALSE)

 

[sksanjeev786]

Conditional format. =IF(LEN(cell)<4,TRUE,FALSE)

thank you a lot, C Moore.

 

[Joe4]

Conditional format. =IF(LEN(cell)<4,TRUE,FALSE)

Just an FYI, equality and inequality formulas return boolean results themselves, so there is no need to wrap them in an IF formula.
You can simply write the formula like:

=LEN(cell)<4

 

[sksanjeev786]

Just an FYI, equality and inequality formulas return boolean results themselves, so there is no need to wrap them in an IF formula.
You can simply write the formula like:

=LEN(cell)<4

Done!!!! thanks Joe for helping on this....