Add a set number of

[EddyB]

Hi all,

Does anyone know of a way to add a set number of

[BobWeaver]

CalculatedText = Text & Left("

[EddyB]

Hi Bob,

Many thanks and apologies, this is a similar answer you gave me for another problem I was having.

I did not think of using this solution for this query - sorry!

Thanks again

Ed.