Hi All
I wonder if someone could please help with an issue I am having.
I have a custom list which has an indexed currency column called Price. I crawled the list and have a crawled property of Ows_q_CURR_Price which I mapped to a refinablestring for a content search web part.
Instead of getting £10.50 I get 10.5000000000000 and I’ve searched and searched and cannot work out how to get the £ sign and 2 decimals to show which is how that column is set up.
Any help or ideas would be greatly received.
Hi Beau, thanks for the information, I’ll check it out. In the end, I had to get it done, so I created a new single line of text column called PriceText and input the price that way. It’s up and working, but I’ll take a look at your link to see if I can edit and do it better. Thanks