> 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?
Can anybody explain what's going on here ? Put two listboxes and two commandbuttons on a form and partially overlap the two listboxes. The code below should alternately bring to the front and then to the rear Listbox2. Private Sub CommandButton1_Click() ListBox2.ZOrder (0) End Sub Private S...
Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like t...
Zoom is on my Toolbar. I click the arrow and a menu drops down. One of the items is Selection. When I click Selection I get 400%. I want 92% not 400%. How do I do it? I've Excel 97 with Win XP....
Hi all, Need to know is it possible to Zoom all sheets in a workbook at once, say have all appear at 200% or whatever, when I go to the Zoom control not just the sheet I am working on. Cheers, Andy....
I have number of worksheets in the one workbook all currently sitting at zoom 127% - I want to konw if there is away I can changed the zoom display all on sheets at once to 75%...
I am trying to sort maybe 7 different columns, and I do not need zeroe values or zeroes in the sort or final sort. I need the lowest number in each column to show. I need help bad to filter ort or value out th zeros and the blank spaces. thank -- Message posted from http://www.ExcelForum.com...
Link them all to cell? Eg.=IF(G9=0,G9,something_else)HTHBob Phillips... looking out across Poole Harbour to the Purbecks(remove nothere from the email address if mailing direct)"LPhiEKicKMyDog" <LPhiEKicKMyDog@discussions.microsoft.com> wrote in messagenews:40B5E512-F939-410E-B835-D8EF48CB...
Link them all to cell? Eg.=IF(G9=0,G9,something_else)HTHBob Phillips... looking out across Poole Harbour to the Purbecks(remove nothere from the email address if mailing direct)"LPhiEKicKMyDog" <LPhiEKicKMyDog@discussions.microsoft.com> wrote in messagenews:40B5E512-F939-410E-B835-D8EF48CB...
I am trying to figure out how to make a group of rows cell values become zero when collapsed and use the last entered value when expanded. Using scenarios is too limited for the number of options I will have. If anyone has any suggestions, I would appreciate it. Thanks....
I'm creating an IF statement to add up cells dependent on whether a cell is blank or not and I can't seem to get Excel to differentiate between a zero and a null cell value. I'm using this to handle original versus revised forecast values where column A is original and column B ar...
I need to turn off the zero values for the majority of one sheet I have, but not for all - there are two rows of cells that need to be able to show zeros. Is there a way to do this? Thanks. Frank...
I need the zero sales products to show up in my pivot table that links to an OLAP cube. I can see the items in the pick lists but can't get them to display in the data....
I want to turn off "Show Zero Value" under the tools menu, but there aresome cells that I would like to show the zero value, and they alreadycontain a formula. Like =F5. Can this be done?Thank You...
i have a problem copying cells between worksheets in the same workbook. most of the cells copy and are linked OK but the 2 final columns in the worksheet table copy and show a zero value. in the formula bar it shows that the cell is copying the correct data. if you copy the data from a cell that...