Experts,
I have a numeric data type column and having values varying from one number to 4 numbers after decimal point. I want to store the values after decimal places into another column.
Please help in this regard
Thanks
Sri
Experts,
I have a numeric data type column and having values varying from one number to 4 numbers after decimal point. I want to store the values after decimal places into another column.
Please help in this regard
Thanks
Sri
If A1:A10 contain your values
B1: =MOD(A1,1)
That will give you the value in numeric terms.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks