Adding leading 0's to singular numbers

[matps]

Hi guys!

So I've got a requirement for something I'm working on.

Basically I'm doing some work for a printer and they've sent over their CMYK print values, ie 85 56 14 1

However the system I'm working on needs these values formatted in a certain way, so 85 56 14 1 needs to become 0.85,0.56,0.14,0.01 to read into the database.

So I've tried to be clever using CONCAT and it's mostly done the trick, however in the case of singular numbers I've ended up with 0.1 which is a different colour to 0.01.

Is there a formula to add a leading 0 but only when it's a singular number, if that makes sense?

Kind Regards,

Matthew

[Fluff13]

Hi & welcome to the board.
How about

Please Login or Register  to view this content.

[matps]

that works an absolute treat, thank you so much!

[Fluff13]

You're welcome & thanks for the feedback.