Originally posted by EyeTalion
is there a way to use .Format = "$#", if the field can be null....I don't want a $ sign in the cell if theres no data?
I am not aware of any way. Why dont you format the field while selecting from the database? There you can put the $ if its not null.