GST Tax comparison report

This query is : Resolved 
Quick Summary
This discussion addresses an issue where formulas in a downloaded GST tax comparison report aren't working because the figures are being treated as text. The user has tried standard formatting options without success and is manually removing commas. They are seeking a more efficient method to convert these text-based numbers into actual numbers within Excel so that the report's formulas can function correctly.

Profile Image

Profile Image

(Querist)
03 December 2021 I have downloaded tax comparison report but formula is not working in downloaded excel sheet...how to convert the figures into numbers so that formulas can work..
I have checked by using format numbers options but not working
Profile Image

CA Altamush Zafar

Profile Image

CA Altamush Zafar (Expert)
03 December 2021 Usually on selected the numbers which are set as text there comes an option to convert them as numbers.
Profile Image

CA Parul Saxena

Profile Image

CA Parul Saxena (Querist)
21 December 2021 no option is there...actually i have to remove comma one by one then text is converting to numbers...is there any other way?
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries


Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member prasanth konaprasanth konaPro Member Prakash KaduluriPrakash KaduluriPro Member chandradhass sathishchandradhass sathishPro Member Ishwarya Keerthi BIshwarya Keerthi BPro Member JAYDEEP MITRAJAYDEEP MITRA
Subscribe to Pro
Join an elite circle of professionals



Answer Query



Quick Links



Browse by Category