how do you make a cell read only the decimal

**bansot** · 07-01-2013, 01:04 PM

Hello everyone. I'm trying to create a formula in a cell that references another cell but I only need it to reference the decimal. How would I go about doing this and is it even possible? Thank you all

**XOR LX** · 07-01-2013, 01:06 PM

Hi,

=MOD(A1,1)

Regards

**bansot** · 07-01-2013, 01:42 PM

Originally Posted by XOR LX

Hi,

=MOD(A1,1)

Regards

Thank you so much. Genius

**XOR LX** · 07-01-2013, 01:45 PM

Wouldn't go that far, but you're welcome!

how do you make a cell read only the decimal

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

how do you make a cell read only the decimal

Re: how do you make a cell read only the decimal

Re: how do you make a cell read only the decimal

Re: how do you make a cell read only the decimal

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions