adding apostrophe at beginning of number

M

Mearnie

Joined
Jun 16, 2009
Messages
4
Reaction score
0
Need suggestions for adding an apostrophe at the beginning of a number, some with leading zeroes, then copy it down 900 rows.
 
You're going to have to be a lot more specific than that to get help... Are you talking about doing this in Excel?
 
Ian Cunningham said:
be a lot more specific than that to get help...
Click to expand...

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



P.S Welcome to the forum
happywave.gif
happywave.gif
happywave.gif
happywave.gif
happywave.gif
 
Last edited:
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.
 
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
 
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
 
Back
Top