Link to home
Start Free TrialLog in
Avatar of ianmtl
ianmtlFlag for Canada

asked on

Formatting Problems with Excel 2010

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.

Thank You

Rob
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

Rob,

Try to select those blank cells and clear its contents. Then, apply the formatting you want. Those cells may follow the new formatting you set.

Importing data from external source may result into formatting issue. So, this sometimes happen.

Sincerely,

Ed
ASKER CERTIFIED SOLUTION
Avatar of deyotter
deyotter

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial