While trying to imput data into my worksheet the sheet is constantly removing my zeros. Such as the number 1200 turns into 12. This is only happening on my...

I use UPC #'s a lot. Most are preceeded by a '0'. When I enter the number, the '0' does not appear and it will not upload to another program. How can I...

I am attempting to upload a csv file but when saving I lose my initial zero in my spreadsheet due to the conversion to csv. I have tried EVERYTHING that I...

In a cell I have formula that uses data from other cells to calculate values. Before data is entered into those cells I always see either zeros or #DIV/0! on...

I need help with a formula. I need to format a column of cells so that if the number in a cell has a value after the decimal place (e.g.: 6.5), it displays...

I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click enter, it changes to 24.95. How can I get it to leave the zero (0) in?

I need to place a Zero in front of a number, but when i press enter, it goes away, how can i keep it there?????

I have a spreadsheet that I calculates monthly data and puts it into a year end management spreadsheet. How do I clear the cells of data (zero out) but leave...

Hi, I am importing some values into an Excel Spreadsheet from a .txt file example imported values a 47.80 1,089.90 I need to format these like so:

Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when...

Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when...

I'm putting together a workbook for logging criminal offenders and victims. I have columns linked on multiple worksheets. I don't know how many entries...

I had posted before about displaying zero's. I wasn't quite as detailed as I should've been with what I needed help on. I have ID numbers that are 9 digits...

I am doing a report where 0 is the first number in the cell, but not for every cell. So they look like this: 094521463 456245654 654621327 When I try to...

Can I have zero format with a slash through it? If I mix numbers (digits) with letters in a cell I want to be able to distinguish zeros from Os with a slash. ...

My chart has about a dozen data series in it, with a legend created for each. A couple of the data series currently are zero amounts, and my boss prefers not...

My formula is A1/A2 however if they are both Zero values it is producing the #DIV/O! If there are Zeros in A1 and A2 how do I get the product to also be Zero...

Would anybody know how I can avoid showing data point gaps on a column chart. E.g. Red Wine 1000 White Wine 0 Rose Wine 1400 How can I avoid...

Hi I currently have some data as shown below: Item 1 0 Item 2 3 Item 3 6 Item 4 5 Item 5 0 Item 6 9

I have a simple formula that inserts a value in a cell from one spreadsheet into the cell of another spreadsheet. If the source cell doesn't have a value,...