Thank you so much! Works a treat!

"joeu2004" wrote:

On Jul 4, 7:12 pm, BB wrote:
I am having trouble with what I am sure is a very simple formula:
I want a formula to enter a number into cell B1 when I enter a
number into cell B2, eg B2 = 5, and I want B1 to display 1005,
with the range being from 1-501 that I will enter into B2, displaying
in B1 1001-100501.

=value("100" & b2)