Typo Checking

[rcocrane99]

Hey Everyone so basically I have a tracker that me and my team fill out multiple times a day and I'd like to limit the amount of typos. for example instead of typing 7.7 an operator types 7,7 and therefor the number isnt taken into consideration in some statistical formulas I need. I share this and they fill it out on a tablet so it cannot have any VBA. see below an example of what I need

 

[dreid1011]

A couple ways you can do it, either highlighting the errors with conditional formatting or preventing the errors with data validation.

Example of CF to highlight the errors:

Book1
	A	B	C
1	1.1	8.43	8.72
2	0	122.2	122.2
3	5	2.1	2.24
4	5.5	4.81	4,95
5	5,6	300	1.17
6	7.7	102	3.66
7	1	1.04	0.72
8	2.9	3.06	4.72
9	3.5	4.15	,06
10	4.6	1.43	9.99
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C10	Expression	=ISNUMBER(SEARCH(",",A1))	text	NO

Data validation preventing the entry of a comma:

DV formula applied to range E1:E10 (DV rule applied to E1, then copy cells to E10 to apply the rule to the range):

=ISNUMBER(SEARCH(",",E1))=FALSE

 

[Artik]

Use conditional formatting with the ISTEXT function.

Artik

 

[rcocrane99]

Hey Artik, could you elaborrate please for me, and I actually agree with istext it isn't specifically a comma but any text I'd like to flag incase there is a mistype

 

[Cubist]

Why not use the built-in Decimal data validation?

 

[rcocrane99]

BINGO! Thanks so much!