I have cells without the 0 in front of the decimal that make my equations not recognize the real value of the number. Either how do i get the 0 in front or how do i get the sheet to recognize the value?
2006-10-12 04:10:06 · 9 answers · asked by Anonymous in Computers & Internet ➔ Software
formatting the cells to be decimal aren't working. I tried that first. The only thing that works for me is clicking on the cell's data, and hitting enter, which pulls up the 0, OR, making a whole new column equal the values of this column. Very weird.
2006-10-12 04:22:22 · update #1
The numbers are probably formatted as text. That happens a lot when exporting data from some other source to Excel. The easiest way to tell is numbers are right-aligned, and text is left-aligned.
If it IS in a text format you can convert all of the affected cells.
Select a blank cell and Copy it.
Select all of your bad numbers, right-click and select Paste Special.
Select Add, and click OK.
2006-10-12 04:25:54 · answer #1 · answered by Hanged Man Bendy 3 · 0⤊ 0⤋
Right click on the cell and go to 'format cell' you will find options here that will automatically format the cell to show the 0. Normally 'General' or 'Custom'. Make sure you copy the formatting down so that each cell has the same formatting. I hope this is what you need.
2006-10-12 04:18:53 · answer #2 · answered by Born a Fox 4 · 0⤊ 0⤋
Sounds like the cell is formatted as a text value. You will know this if the is a single quote (') in front of the number. You will have to edit out that ' for the number to appear correctly.
-MM
2006-10-12 04:45:26 · answer #3 · answered by Anonymous · 0⤊ 0⤋
You could make a column which appends a zero before EVERY entry in the data column. Presumably an entry like 03.99 will not be a problem. Now run the calculations on the new column.
2006-10-12 04:15:47 · answer #4 · answered by poorcocoboiboi 6 · 0⤊ 0⤋
You have to Format --> Cells. Excel converts data in the cells based on what it thinks it is or whatever you command the format should be.
2006-10-12 04:19:40 · answer #5 · answered by Anonymous · 0⤊ 0⤋
Specifically format those rows/columns as type numeric/2 decimal places? Otherwise Excel might assume they are text or something else...
2006-10-12 04:16:09 · answer #6 · answered by Proto 7 · 0⤊ 0⤋
You can format the cell to show the zero. Change the format to GENERAL.
2006-10-12 04:19:24 · answer #7 · answered by Marvinator 7 · 0⤊ 0⤋
Right click on the cell, chose format text and then select the desired option..
2016-03-28 06:23:40 · answer #8 · answered by Anonymous · 0⤊ 0⤋
when entering the number did you first type the + sign (ie, "+0.399" ) otherwise it is probably being taken as a text entry.
2006-10-12 04:18:55 · answer #9 · answered by kbugiell 5 · 0⤊ 0⤋