In my excel spreadsheet I am having formatting problems. In some cells I have zeros and in others there are dashes. How do I get them to be the same. I have tried to copy and paste also checked to make sure the the format cells were the same. I don't know what to do?
2006-10-18 03:17:29 · 5 answers · asked by Violet 4 in Computers & Internet ➔ Programming & Design
It can be either or.....zero's or dashes. Just one or the other.
2006-10-18 03:22:24 · update #1
If the cells have the exact same formatting but some show zeros and some show dashes then it is possible that the value of the cells with zeros is "0" and the value of the cells with dashes is "null" or essentially has no value (i.e. empty). It may also have this result with certain "functions." If this is not the case, then it is very likely that the formatting for the cells is not truly identical.
2006-10-18 03:28:08 · answer #1 · answered by Chris 2 · 0⤊ 0⤋
dash instead of 0 is an accounting format.
If you want the same cell format to apply to a whole column
right clic on the column letter, choose cell format, number tab and select (or create) the format you need
2006-10-19 08:03:05 · answer #2 · answered by Anonymous · 0⤊ 0⤋
The Microsoft Newsgroup site has many Experts that can give you presise explainations how to do virtually anything in Excel
2006-10-18 12:28:30 · answer #3 · answered by reinders1 4 · 0⤊ 0⤋
DO u want zeros or dashes ?
2006-10-18 10:18:46 · answer #4 · answered by Leo 3 · 0⤊ 0⤋
visit microsoft.com/office
2006-10-18 10:19:39 · answer #5 · answered by faisal k 2 · 0⤊ 0⤋