I have a problem with formatting some cells in Excel.
It usually occurs when I export the spreadsheet from Access. The cell is blank so I am assuming it is coming over as null. When I go and try to format the empty celll it will not format. I will as a rule try and format as number or currency. When I reference the cell in a formula I get an error message.
How can I format these types of cells? I have even gone as far highlighting the whole colum and selecting a number format. These blank (or nulll) are pretty stubborn!!
Any help would be appreciated.