Converting numbers with minus sign into negative numbers in Excel

CA Rishabh Pugalia (ExcelNext) , Last updated: 26 April 2021  
  Share

There are series of numbers, wherein some of the numbers are ending with minus sign (-). Now, if you want to apply sum, min, max or average functions, it will not work correctly as Excel cannot read 3789- as a negative. Although,it is rare to see this kind of data set in todays world, if youare w

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 1999/-

Offer Price : INR 999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Info Technology   Report

Other Articles  
Comment   Share
2 Likes   15909 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro

Trending Online Classes

view all classess

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category