Add data to field

G

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
 
P

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
Click to expand...

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).
 
Top