Add data to field

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
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).
 
Back
Top