Hi Shawn,

Is this what you are looking for, or are you looking for something
VBA-related?

=A1&A2&TEXT(A3/1000,".000")

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


43fan wrote:
I have a string that's made up of concatenating other variables
together, one of which is a numerical value. I want to put leading
zeros on the numeric value, up to a full string length of 3.

Ex:
A = Y (string)
B = 1234 (string)
C = 1 (numeric)
A B C
Final string would look like this: Y1234.001

Help???

Thanks!
Shawn