Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Issue - Zero's not being displayed
I can't seem to find a newsgroup that fits this issue. I have a template
workbook that I've built a fairly involved formatting macro, and it's working fine. When I did a thorough check between the Excel data presentation and some reports from the database I noticed that in some cases the spreadsheet is not showing values that are zero percent... If I copy the cells and paste special into a new workbook (first values, and then formats) the zero percents will show (and entries with no calculation are still blank). I'm pretty perplexed how this "hide all zero values" is being accomplished...and would like to get rid of it. Any hints from the Excel guru community would be helpful. TIA! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Issue - Zero's not being displayed
Hello
Tools, Options, View tab and tick "zero values" Save the workbook. HTH Cordially Pascal "Ed Ardzinski" a écrit dans le message de news: ... I can't seem to find a newsgroup that fits this issue. I have a template workbook that I've built a fairly involved formatting macro, and it's working fine. When I did a thorough check between the Excel data presentation and some reports from the database I noticed that in some cases the spreadsheet is not showing values that are zero percent... If I copy the cells and paste special into a new workbook (first values, and then formats) the zero percents will show (and entries with no calculation are still blank). I'm pretty perplexed how this "hide all zero values" is being accomplished...and would like to get rid of it. Any hints from the Excel guru community would be helpful. TIA! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting toolbar is not displayed | Excel Discussion (Misc queries) | |||
Formatting numbers with leading and trailing zero's | Excel Worksheet Functions | |||
Please help me... Set precision as displayed issue | Excel Discussion (Misc queries) | |||
Cell Formatting Incorrectly Displayed | Excel Discussion (Misc queries) | |||
Cell Formatting Advice:- Text displayed as .........####### | Excel Discussion (Misc queries) |