Hi Martin,

Am Tue, 12 Nov 2013 15:13:38 +0000 schrieb Martin ©¿©¬:

So everytime I input a number I have to do that?
Is ther a better way?

what do you mean? To ignore the error? You can go to Excel options =
Formulas and deactivate this error.
If your cells are adjacent all same errors will be ignored if you once
do it.
If you mean the formatting you can format the whole column to text.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2