"Text to column" will work even if the cell has any digit of number
and will convert 100- to -100
Very useful article sir,
But what to do if all the numbers are not of same no. of Digits..
You need to be
logged in to post comment
Enter your email address to subscribe Articles on email.
You can also submit your article by sending to firstname.lastname@example.org
view more »
Our Network Sites
Download CAclubindia App
Alternatively, you can log in using:
Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.