adding apostrophe at beginning of number

[Mearnie]

Need suggestions for adding an apostrophe at the beginning of a number, some with leading zeroes, then copy it down 900 rows.

 

[Ian]

You're going to have to be a lot more specific than that to get help... Are you talking about doing this in Excel?

 

[Mearnie]

Yes, Excel. Sorry.

You're going to have to be a lot more specific than that to get help... Are you talking about doing this in Excel?

 

[Madxgraphics]

be a lot more specific than that to get help...

Ok now we know it is Excel,but can you be more specific as to what you are actually trying to do...?



P.S Welcome to the forum

 

[Mearnie]

Trying to insert an apostrophe before number in an attempt to prevent the number from turning into a date when I save it as a .csv.

 

[Ian]

What happens if you change the cell formatting to inform Excel that it's just a number, not a date?

Right Click Cell > Format Cell > Number > Number > OK

 

[Mearnie]

No luck with that.

 

[excellerator]

You could insert a column before your numbers, insert a =concatenate formula...

e.g. =CONCATENATE("'",B1)

And drag that down or double click the auto fill tag.

Otherwise have you tried formatting the cell as a 'Text' cell?

D