"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
You can also submit your article by sending to email@example.com
view more »
Our Network Sites
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.