Add data to field

[Guest]

I would like to add 2003- to an existing field that has a
range of different numbers in it. Ex. From: 167 to 2003-
167.
Thank you for any assistance

 

[Nick Hodge]

data in A2

In a blank cell...

="2003-"&A1

and copy down as far as needed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Paul]

I would like to add 2003- to an existing field that has a
range of different numbers in it. Ex. From: 167 to 2003-
167.
Thank you for any assistance

For a number in A1, use this formula:
="2003-"&A1

Note that the result is a text string, not a number (as it contains a
hyphen, which is not a numeric character).