Null Values and MYSQL

[ckroon]

Hi all. Not sure if this is the right forum... but I think it may be.
I am using excel to upload data to a MYsql database. I have a database field set to default to a certain value if the field is empty... but when I upload anything, teh empty field gets interpreted as a Zero and my default value doesn't get triggered. Big headaches. IS ther any way to input a (Null) value in an excel field or do I ahve to attack this problem from the other end?

Thanks!

 

[ckroon]

MY question is getting buried nooooooo!