Hi there !
I spent a couple minutes to find a trick into a rep to obtain a special numeric format for a column. I mean, into a column I have a indicator with different value, some with a long decimal and some without any number after the comma. So, I’d like to get in the same column something like that (cause the datas are like that in entry => Excel file):
Ex:
Product A 12365
Product B 65
Product C 12,365
Product D 1,2365
Product E 365
Product F 1236,5
…
I didn’t find after a quick search on BOB (maybe I say some craps… thanks supervisor for deleting this post !).
I found a solution, if someone gets a better one or I share that one with you. I’ve just concat with an empty string like that :
=& " "
cheers
@+ kenny
kenny (BOB member since 2007-01-02)