Solved

Formatting Problems with Excel 2010

Posted on 2010-09-07
2
561 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:ianmtl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 33619986
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
0
 
LVL 1

Accepted Solution

by:
deyotter earned 500 total points
ID: 33620061
I can think of thre options you could try:
You can edit one of the 'blank' cells, copy whatever seems to be in it and then use the replace feature to find all instances and replace with nothing.
You could also try the Filter option and display only blank items in that column then select and delete the visible cells.
The last option I can think of is you could create a macro that would insert a new column and use the CLEAN function to remove the unwanted characters.  Then the macro could copy the correct column and paste special just the values over the original column and finally remove the extra column.
Of course before attempting any of these options I woudl make a copy the spreadsheet so that you have it to fall back on.
Good luck,
Lorrie
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question