How to concatenate numbers with 2 fixed decimals

So, you don't want every cell reference in that formula to have FIXED( ... ,2) around it?

Another way of doing it would be to use the TEXT function, i.e.:

TEXT(B84,"0.00")

(this is in English, but you will probably have to use a semicolon instead of the comma and a comma instead of the full stop), but if you only need to do this to selected cells then you could adapt the following procedure:

put an apostrophe ( ' ) before the = sign in the cell with the formula, then put

TEXT(

(or the Dutch equivalent) in another cell. Click on the formula bar as if to edit the cell, highlight the contents and do CTRL-C to copy it, then press the < Esc > key. Then click on the cell with the CONCATENATE formula in it and click on the formula bar and then move the cursor to just in front of the cell reference for a number, and then do CTRL-V to paste the TEXT( characters in front of the cell reference. Continue to do this for the other cell references which contain numbers.

Then you can repeat this sequence by putting the second part of the function in the temporary cell, i.e.:

;"0,00")

and then copy this and press < Esc > again, then paste it after those cell references that you have already amended.

Finally, you can delete the apostrophe from in front of the = sign.

Hope this helps.

Pete

Hi Pete, I will try this tomorrow first thing in the morning and will let you know if it worked!

Thanks!

Hi Pete,

Eventually I used your copy paste strategy with the normal fixed function. Its the shortest way, because FIXED( is using two decimals by default. Thanks for the help!

Best regards,
Bas

Glad to hear that you got it sorted in the end.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete