User Defined Function To Add A Zero In A Concatenated Formula

Good Morning Team

For the life of me I have no idea how to do this or even if it is possible.

I have this formula

IF(LEN(F4/4)-FIND(".",F4/4)=1,F4/4&"0",F4/4)

which I use to add a 0 to a value that would normally end in for example ".2".

I would like to create a User Defined Function that I could just pass the values, or cells and values to it, and it would produce the required result.

The reason I want this is due to I am using the Concatenation feature to build up a statement.
something like this.

="Some text "&C5&" some more text "&D12/2&" Total = £ "&F23

Now you will know that if the values in the cells within the above formula end up as for example £5.20, they will be displayed as £5.2

To make it look and read better, I want to add the "0", but only need to add the zero if needed. So values like £5.22 would not need the zero added,

Hope all that makes sense, and any help would be appreciated.

Many thanks

BanburyS

You should just be able to use the TEXT function:

="Some text "&C5&" some more text "&D12/2&" Total = " & TEXT(F23,"£0.00")

Hi Andrew

Many thanks for taking the time to reply.

Blindingly obvious when you know how. I have never really thought of using the TEXT Function.