DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Software Q&A

Command/way to change rate % in excel

13 posts · originally from https://geek.digit.in/community/threads/command-way-to-change-rate-in-excel.196841/

B
billubakra Original post #1
Apr 2, 2016 at 3:58 PM
Hi Guys,

Please check the screenshot.

*oi66.tinypic.com/1zcepo7.jpg

How to change the rate of service tax to 15% from 14.5%?

Thanks
nac
nac #2
Apr 2, 2016 at 4:56 PM
You kidding? Go to the cells and change it.
B
billubakra #3
Apr 2, 2016 at 5:12 PM
nac said:
You kidding? Go to the cells and change it.
Click to expand...

I tried that dear but it didn't do anything. When I change it to 15% nothing happens.
nac
nac #4
Apr 2, 2016 at 5:17 PM
Upload that file and share it.
nac
nac #6
Apr 2, 2016 at 6:11 PM
billubakra said:
Bill file of college. Not allowed to do that.
Click to expand...
Then not a lot we can do, can we?
If possible move/copy that worksheet in question in a new file and share it. If not possible, don't worry. One way or other you will figure it out or someone next to you who can access the file will help you fix it.
B
billubakra #7
Apr 3, 2016 at 2:41 PM
nac said:
Then not a lot we can do, can we?
If possible move/copy that worksheet in question in a new file and share it. If not possible, don't worry. One way or other you will figure it out or someone next to you who can access the file will help you fix it.
Click to expand...

PFA

TinyUpload.com - best file hosting solution, with no limits, totaly free
nac
nac #8
Apr 3, 2016 at 3:11 PM
billubakra said:
PFA

TinyUpload.com - best file hosting solution, with no limits, totaly free
Click to expand...
There's nothing complex in this worksheet. It's a very simple one... Is this your first time working in excel?
TinyUpload.com - best file hosting solution, with no limits, totaly free
B
billubakra #9
Apr 3, 2016 at 8:26 PM
nac said:
There's nothing complex in this worksheet. It's a very simple one... Is this your first time working in excel?
TinyUpload.com - best file hosting solution, with no limits, totaly free
Click to expand...

Thanks dear. How did you do it? I will do it in the bill files myself. Not the first time, but these commands etc. are not my cup of tea.
nac
nac #10
Apr 3, 2016 at 8:46 PM
billubakra said:
Thanks dear. How did you do it? I will do it in the bill files myself. Not the first time, but these commands etc. are not my cup of tea.
Click to expand...
Press CTRL + ` to view the formulas and see what's the change before (the file you uploaded) and after (the file I uploaded).
Dear, you have to pick up Excel 101 and learn.
B
billubakra #11
Apr 3, 2016 at 9:41 PM
nac said:
Press CTRL + ` to view the formulas and see what's the change before (the file you uploaded) and after (the file I uploaded).
Dear, you have to pick up Excel 101 and learn.
Click to expand...

Thanks brother. Will download the pdf of one o one asap.
B
billubakra #12
Apr 21, 2016 at 12:37 PM
[MENTION=125321]nac[/MENTION]
Sir, can you please help in copy pasting the same data as it is in the attached word file to excel? We tried it, but the tables etc. are getting changed in excel

TinyUpload.com - best file hosting solution, with no limits, totaly free

And if you have any other good invoice template in excel then please share.
nac
nac #13
Apr 21, 2016 at 2:52 PM
I don't remember if I have ever done something like this. I don't think you can just simply copy/paste this content as it is. Better create one in Excel from scratch or you can modify the template.

No, I don't have any invoice template. Google and see if you can find a good one...