excel question how change ####### (shows way when data exceeds cell can display) in cell n/a without using vba? can manually expanding width of column want keep spreadsheet small , don't need 9999999% meaningless. in advance.
select 1 or more cells want change; perhaps start cells showing 'meaningless' values 9999999%. note 'active cell'. typically cell in top-left corner of selected group of cells. sake of demonstration, cell d2.
use home ► styles ► conditional formatting ► new rule. when new formatting rule dialog opens, choose use formula determine cells format supply following in format values formula true: textbox.
=abs(d2)>10 a raw value of 10 1000%. greater 1000% or less -1000% receive conditional formatting. note d2 involved in formula.
click format , when format cells dialog opens, go number tab , choose custom list down left. supply following in type: textbox,
"n/a" click ok accept new formatting ok again create new rule.
repeat other cells may have values showing other scope(s) consider 'meaningless'.
Comments
Post a Comment