special format for decimal numbers...

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):
:arrow_forward: 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 !). :nopity:

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 :fr: (BOB member since 2007-01-02)

can you make this more clear.


Rakesh_K :india: (BOB member since 2007-12-11)

ok sorry for my bloody explanations… the best way is a demo !
look at the file attached

cheers
demo.zip (194.0 KB)


kenny :fr: (BOB member since 2007-01-02)