Thread
:
how do i get only the decimal value in excel
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
MartinW
external usenet poster
Posts: 860
how do i get only the decimal value in excel
Hi vardoo,
=A1-INT(A1) will return 0.45
=(A1-INT(A1))*100 will return 45
HTH
Martin
Reply With Quote
MartinW
View Public Profile
Find all posts by MartinW