What is the formula that brings back a zero for an empty cell instead of 0 0 #DIV/0!

I am trying to customize my tool bars by adding existing icons from the custom list, not normally a problem. Recently, I have tried to add the "Mail...

I want to be able to return to where I last entered data when reopening a document. I woud like to be able to do this with a keystroke instead of scrolling...

When writing checks, I would like to have Excel recognize the text version of the currency amount automatically (example, $6,100.00 to display as "Six thousand...

I have data in multiple colums that has been subtotalled by the sum function. I now wnt to copy and paste or export only the rows containing the subtotals to a...

I would appreciate any assistance. The text in my excel spreadsheet is being truncated when perfoming a mail merge into Word. I'm running Office 2003. Is...

I have a text file of data that i get on a daily basis and have to perform the 'text to column' function on each time. Is there a way that i can just place the...

Prints 5 pages when have only small amount of information

I'm now working in a bi-lingual facility and need to create several spreadsheets in Spanish that I already have saved in English. Is there a way to change the...

How do I change the font color and make it bold within a formula? I am trying to link two different cells with text in them to one cell and I would like to...

I am trying to make a document that is a daily processing cost for my supervisor. It is actually in week form. I need to times the daily rate by hours worked...

I'm using forumulas like these to extract data from several different files: =SUM('Coins\Group Costs'!$A$3). I have a column that has all the filenames listed,...

a black and gray object like a radio button appeared in the upper left corner of a cell after a cut/paste action. there was a radio button in the...

My spreadsheet has a formula repeated in each cell of a column. Is there anyway that I can insert rows without having to manually copy down the formula each...

I have a genral question regarding the vlookup function. I have noticed that there are some vlookup fromulas that have a the lookup array that is 1/(condition)...

When Help is selected in Excel the Help window extends beyond the Excel window's right hand side. Scroll bar is available but it would be much more convenient...

hi i would like to change the color of my text, for different condition in a IF formula. I know that it's posible but a just don't remember the syntax. ex:...

Hi, i need to be able to open a .csv file in Excel with large numbers and or Leading zeros without having to put a ' single quote in or format the column as...