I believe that you are limited to two conditions when creating aCustom Format.This works fine for identifying "0" values.[>=10000000]#\,##\,##\,##0;[=0]"Nil";##,##0