A "spell check" for numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 10 Feb 2007 05:48 GMT

Hi
I have an excel sheet (template) where I enter numbers. Sometimes the
same numbers are entered twice, which is a good thing since it can
pick up mistakes if they are compared by the computer. For example:
12345
12354
Can the computer compare numbers that appear similar, somewhat like a
spell check? If there is no function, can their be a vba solution for
this?
Any input appreciated
Thanks

Reply to this Message

Bernd - 10 Feb 2007 07:44 GMT

To prevent somebody to enter values twice you can apply a conditional
format to show a red background if the value already exists, for
example.

If your project is of some significant size - let's say like setting
up bank account numbers or ISBN's - then you might consider setting up
check digits: http://en.wikipedia.org/wiki/Check_digit

[20% of all unchecked human data input is wrong]

Regards,
Bernd

Reply to this Message

David Biddulph - 10 Feb 2007 08:30 GMT

Yes. If you are entering the number in coumns A and B as a check, you can
conditional format with formula is =$A1=$B1 to show green and/or
=NOT($A1=$B1) to show red.

Signature

David Biddulph

> Hi
> I have an excel sheet (template) where I enter numbers. Sometimes the
[quoted text clipped - 7 lines]
> Any input appreciated
> Thanks

Reply to this Message