I have a number that started out 14 decimal places and I want to take it down to only two:
So 1.00052423747213 will become 1.00
I know how to format the cell to only show 1.00 but I want the true number in that cell to be 1.00. How do I convert?
Thanks for the help!
=round(a1,2)
To round up use
=roundup(A1,2)
To round down use
=rounddown(A1,2)
Life's a spreadsheet, Excel!
Say thanks, Click *
For it to not round at all...Just cut off digits after the 2nd decimal..
=TRUNC(A1,2)
Awesome, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks