Hi All,
I'm looking for a formula to break number in to decimal . Which means for 5 digits i.e 12555 to 12.5 and 4 digits i.e 1555 to 1.5
Thanks in advance.
Regards,
Nawas
Hi All,
I'm looking for a formula to break number in to decimal . Which means for 5 digits i.e 12555 to 12.5 and 4 digits i.e 1555 to 1.5
Thanks in advance.
Regards,
Nawas
In A1 Cell
12555
In B1 Cell
=IF(LEN(INT(A1))>3,LEFT(A1,LEN(INT(A1))-2)*0.1,"")
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Or just =A1/1000
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
maybe also add a trunc
=TRUNC(A1/1000,1)
1555 didn't rounded to 1.6
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you all and much appreciated...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks