How to Convert -ve values into 0 in some column of Excel?

Help Activities
, ,
21

I understand your logic but how can i use any particular sheet within the file ? I have 3 sheets and I have to change sheet2 and column H values from -ve to 0.

22

Hi @PALKUMARI_PATEL

Try this

image
image882×1216 43.4 KB

Code:

Replace Negatives.txt (538 Bytes)

Hope this helps!!

1 Like
23

@PALKUMARI_PATEL

Please find the below xaml for your reference

BlankProcess14.zip (72.5 KB)

O/P:
Book1 (6).xlsx (9.8 KB)

Hope this helps!!

1 Like
24

This is working absolutely fine in my worksheet. thank You so much for the suggestion and your help.

1 Like
25

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.