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 wrote:
> Why don't you use the option
>
> 'Show zero in cells that have zero value', in the advanced tab of Excel
> options (Excel 200
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 wrote:
> Dear Sir,
>I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
> would like
please share some example
.
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar wrote:
> 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-
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
=TIME(2,DO:IT,N:OW
