hello, everyone
i want to change my all number to zero except first three number,
like :
150070
now i want result
150000
thanx
hello, everyone
i want to change my all number to zero except first three number,
like :
150070
now i want result
150000
thanx
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Hi,
You can use REPLACE to achieve that. Check out this website:
https://www.ablebits.com/office-addi...ute-functions/
Example: With "150070" in cell B3
Hope this is helpful.Please Login or Register to view this content.
Cheers
Thanx for reply
but
from 5758959 to i want result = 5758000
i mean
i want to replace last 3 numbers to zero,
like
5766 = 5000
17899 = 17000
595003 = 595000
5951045 = 5951000
thanx
Use this:
=1000*INT(A1/1000)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Worked for me
thanx alot
will add repu +1
You're welcome and thanks for the Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks