Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may contain
any ALPHA-NUMERIC values. ] Pl Help.
=mangal ho
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
please share some example
.
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may
Why don't you use the option
'Show zero in cells that have zero value', in the advanced tab of Excel
options (Excel 2007)
Sam Mathai Chacko
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric
have u tried using simple find and replace to replace all 0 with blank
[image: Inline image 1]
Regards
Ashish
On Tue, Mar 5, 2013 at 10:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Why don't you use the option
'Show zero in cells that have zero value', in the advanced tab of Excel