In this tutorial I demonstrate how to display numbers and dates correctly when they are embedded within a text entry.

The screenshot below is from a simple loan calculator. The sentence in A7 is generated by combining the contents of B3, B4 and B5 with static text


However, if you simply enter

=B4 & ” payments of ” & B3 & ” will be taken from your account starting on ” & B5

You will get this:


The video below shows how to format the number and date to display correctly: