Format column which contains values like 12.4.8

%3CLINGO-SUB%20id%3D%22lingo-sub-1877619%22%20slang%3D%22en-US%22%3EFormat%20column%20which%20contains%20values%20like%2012.4.8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1877619%22%20slang%3D%22en-US%22%3EI%20need%20help%20on%20how%20to%20format%20the%20col%20which%20has%20value%20like%2012.4.8%20(%20iOS%20version).%20Donnie%20want%20to%20round%20off%20need%20all%20the%20values%20to%20apply%20filter.%20Pls%20let%20me%20know%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1877619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1878372%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20column%20which%20contains%20values%20like%2012.4.8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1878372%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F378240%22%20target%3D%22_blank%22%3E%40Keerthib%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20does%20a%20value%20like%2012.4.8%20represent%3F%20Is%20it%20a%20date%3F%20Is%20it%20even%20a%20number%3F%20Or%20is%20it%20text%20made%20up%20of%20digits%20(as%20in%20a%20Serial%20Number%20of%20a%20product)%3F%26nbsp%3B%20If%20a%20number%2C%20what%20kind%20of%20number%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20might%20be%20--%20and%20this%20is%20just%20a%20guess%20because%20you%20don't%20give%20enough%20information%20to%20do%20anything%20other%20than%20guess%20--%20that%20what%20you%20should%20be%20doing%20in%20order%20to%20filter%20is%20to%20separate%20the%20cells%20in%20this%20single%20column%20into%20three%20separate%20columns%20%5Btreat%20it%20as%20text%2C%20and%20use%20the%20text%20functions%20%3CSTRONG%3ELEFT%3C%2FSTRONG%3E%2C%20%3CSTRONG%3EMID%3C%2FSTRONG%3E%20and%20%3CSTRONG%3ERIGHT%3C%2FSTRONG%3E%20to%20separate%5D%2C%2C%20and%20apply%20the%20filters%20to%20those%20three%20separate%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20you'll%20need%20to%20come%20back%20with%20a%20much%20more%20complete%20description%20of%20what%20you're%20doing%20to%20get%20more%20than%20a%20guess.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
I need help on how to format the col which has value like 12.4.8 ( iOS version). Donnie want to round off need all the values to apply filter. Pls let me know
1 Reply
Highlighted

@Keerthib 

 

What does a value like 12.4.8 represent? Is it a date? Is it even a number? Or is it text made up of digits (as in a Serial Number of a product)?  If a number, what kind of number?

 

It might be -- and this is just a guess because you don't give enough information to do anything other than guess -- that what you should be doing in order to filter is to separate the cells in this single column into three separate columns [treat it as text, and use the text functions LEFT, MID and RIGHT to separate],, and apply the filters to those three separate columns.

 

But you'll need to come back with a much more complete description of what you're doing to get more than a guess.