Hello
I have a column with values such as
123.45
v110.5
456.1
I need to remove the decimal points from these values without it doing any rounding. Currently i am using this formula:
=SUBSTITUTE(TEXT(M5,"0"),".","")
But when i use this formula it rounds the numbers.
Any Suggestions?
Thanks
Hi ringrim,
Not sure why you're using the TEXT(M5,"0") section, as that's what is causing the rounding I believe.
Does this not work:
=SUBSTITUTE(M5,".","")
If not, give a few examples and your expected results.
How about changing the formatting to "Number" with "0" decimal spaces?
That would show the numeric values as rounded, and have no effect on the cells that contain alphanumerics.How about changing the formatting to "Number" with "0" decimal spaces?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks