Formula

[dima85]

Hi All

I have a column of 653 Numbers and I want to add "1-" to all of them. Is there a formula I can use to do this so all numbers read 1-1000, 1-2000 etc.
In my case,It does not work if I only make changes through the "format cell" option, because the value of the cell still stays the original number (even though after having formatting them with "1-" I see 1-1000). I then import these values to Quickbooks

Thanks

 

[RonB1111]

Try:
="1-"&A2

 

[dima85]

Thanks a lot It worked