Hi
Thank you for the assist
I have two columns of $ amounts
Currently formatted as 0.00 with number format and , separate for 1000's
I need to filter the zeros OUT
but if a cell in one column has anything but a zero then the cell with the zero remains
the exception is the scientific values being hidden by the format
Numbers like -1.74615877313045E-12 or 2.33058017329313E-12 will not filter out because the zeros are only formatted. I need to know how to filter only $ values (even if they are negative) up to three decimals
ie 0.005 would be saved even if it showed as rounded to 0.01 (whether negative or positive)
Thank you again.
I really need this answered. I appreciate the help.
- g
Thank you for the assist
I have two columns of $ amounts
Currently formatted as 0.00 with number format and , separate for 1000's
I need to filter the zeros OUT
but if a cell in one column has anything but a zero then the cell with the zero remains
the exception is the scientific values being hidden by the format
Numbers like -1.74615877313045E-12 or 2.33058017329313E-12 will not filter out because the zeros are only formatted. I need to know how to filter only $ values (even if they are negative) up to three decimals
ie 0.005 would be saved even if it showed as rounded to 0.01 (whether negative or positive)
Thank you again.
I really need this answered. I appreciate the help.
- g