|
|
Adding an apostrophe to a column of numbers
Hello, I need to add an apostrophe to each cell in a long column of numbers.
I do not want to format them as text or format them as custom - our system
requires the apostrophe at the beginning of the cell. My question is - is
there a way to format one cell with the apostrophe and then copy that
apostrophe down to the other cells?? or can someone write me something that
will allow me to do it quickly? I want to avoid having to go into each cell
and put the apostrophe in! Thank you in advance....
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/12/2010 4:15:01 PM |
|
One way. Change 9 to your column
Sub addapostophe()
mc = 9 'column I
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
Cells(i, mc).Value = "'" & Cells(i, mc)
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"Denise C." <DeniseC@discussions.microsoft.com> wrote in message
news:72FCA0EF-66A4-4458-B795-4BCDD12545EE@microsoft.com...
> Hello, I need to add an apostrophe to each cell in a long column of
> numbers.
> I do not want to format them as text or format them as custom - our system
> requires the apostrophe at the beginning of the cell. My question is - is
> there a way to format one cell with the apostrophe and then copy that
> apostrophe down to the other cells?? or can someone write me something
> that
> will allow me to do it quickly? I want to avoid having to go into each
> cell
> and put the apostrophe in! Thank you in advance....
|
|
|
0
|
|
|
|
Reply
|
Don
|
3/12/2010 4:28:22 PM
|
|
I would create an additional column. That way you don't lose the
functionality of the numbers. Use a formula like:
="'"&Text(a1,"0.00")
The first part is double-quote, apostrophe, double-quote.
Regards,
Fred
"Denise C." <DeniseC@discussions.microsoft.com> wrote in message
news:72FCA0EF-66A4-4458-B795-4BCDD12545EE@microsoft.com...
> Hello, I need to add an apostrophe to each cell in a long column of
> numbers.
> I do not want to format them as text or format them as custom - our system
> requires the apostrophe at the beginning of the cell. My question is - is
> there a way to format one cell with the apostrophe and then copy that
> apostrophe down to the other cells?? or can someone write me something
> that
> will allow me to do it quickly? I want to avoid having to go into each
> cell
> and put the apostrophe in! Thank you in advance....
|
|
|
0
|
|
|
|
Reply
|
Fred
|
3/12/2010 4:39:27 PM
|
|
I undertand that you want to change the cell contents. Use
= "'" & A1
(first one is double quote, single quote and double quote)
Then copy the result and Paste Value to A1
Hope this helps.
"Denise C." wrote:
> Hello, I need to add an apostrophe to each cell in a long column of numbers.
> I do not want to format them as text or format them as custom - our system
> requires the apostrophe at the beginning of the cell. My question is - is
> there a way to format one cell with the apostrophe and then copy that
> apostrophe down to the other cells?? or can someone write me something that
> will allow me to do it quickly? I want to avoid having to go into each cell
> and put the apostrophe in! Thank you in advance....
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/12/2010 4:40:04 PM
|
|
Thanks everyone! I used Hakyab's & Fred's method and it worked like a
charm!! Don, appreciate the code, may try that out when I have more time....
really appreciate the quick replies!! Have a blessed day!!
Denise
"Denise C." wrote:
> Hello, I need to add an apostrophe to each cell in a long column of numbers.
> I do not want to format them as text or format them as custom - our system
> requires the apostrophe at the beginning of the cell. My question is - is
> there a way to format one cell with the apostrophe and then copy that
> apostrophe down to the other cells?? or can someone write me something that
> will allow me to do it quickly? I want to avoid having to go into each cell
> and put the apostrophe in! Thank you in advance....
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/12/2010 5:47:02 PM
|
|
Glad to help. Thanks for the feedback.
Fred
"Denise C." <DeniseC@discussions.microsoft.com> wrote in message
news:2EDA2A70-0D47-4A6C-8F9A-83F82CA66840@microsoft.com...
> Thanks everyone! I used Hakyab's & Fred's method and it worked like a
> charm!! Don, appreciate the code, may try that out when I have more
> time....
> really appreciate the quick replies!! Have a blessed day!!
> Denise
>
> "Denise C." wrote:
>
>> Hello, I need to add an apostrophe to each cell in a long column of
>> numbers.
>> I do not want to format them as text or format them as custom - our
>> system
>> requires the apostrophe at the beginning of the cell. My question is - is
>> there a way to format one cell with the apostrophe and then copy that
>> apostrophe down to the other cells?? or can someone write me something
>> that
>> will allow me to do it quickly? I want to avoid having to go into each
>> cell
>> and put the apostrophe in! Thank you in advance....
|
|
|
0
|
|
|
|
Reply
|
Fred
|
3/12/2010 9:15:12 PM
|
|
|
5 Replies
1189 Views
(page loaded in 0.086 seconds)
Similiar Articles: Adding an apostrophe to a column of numbers - microsoft.public ...Hello, I need to add an apostrophe to each cell in a long column of numbers. I do not want to format them as text or format them as custom - our sys... How do I markup a column of numbers without adding a column ...Adding an apostrophe to a column of numbers - microsoft.public ... How do I markup a column of numbers without adding a column ... I am trying to markup a column of ... Numbers in a column won't add up - microsoft.public.excel.misc ...Adding an apostrophe to a column of numbers - microsoft.public ... Numbers in a column won't add up - microsoft.public.excel.misc ... We use ACCESS to export schedules in ... How to arrange number? - microsoft.public.excel.miscAdding an apostrophe to a column of numbers - microsoft.public ... How to arrange number? - microsoft.public.excel.misc Hi I have a column of around 2000 customer mobile ... How add a digit to front of number in each cell in excexl column ...Adding an apostrophe to a column of numbers - microsoft.public ... How add a digit to front of number in each cell in excexl column How add a digit to front of number in ... How do I add numbers across columns of a single record ...Adding an apostrophe to a column of numbers - microsoft.public ... How do I add numbers across columns of a single record ... I have a column that lists items. Excel - Adding positive or negative numbers in a column ...Adding an apostrophe to a column of numbers - microsoft.public ... Excel - Adding positive or negative numbers in a column ... How do I add only the positve numbers in a ... formula for finding numbers that add up to a spicific number ...Adding an apostrophe to a column of numbers - microsoft.public ... formula for finding numbers that add up to a spicific number ... Adding an apostrophe to a column of ... formula to add a number to a long string ** - microsoft.public ...Adding an apostrophe to a column of numbers - microsoft.public ... Hello, I need to add an apostrophe to each cell in a long column of numbers. ... you don't lose the ... space before Aposterphe - microsoft.public.outlook.general ...Adding an apostrophe to a column of numbers - microsoft.public ... Hello, I need to add an apostrophe to each cell in a long ... customer mobile numbers, the numbers are ... Excel - Adding Apostrophe To Cells - We have a column... - Free ...Adding Apostrophe To Cells - We have a column of numbers that need to have an apostrophe... - Free Excel Help Adding an apostrophe to a column of numbers ExcelHello, I need to add an apostrophe to each cell in a long column of numbers. I do not want to format them as text or format them as custom - our system re Adding an apostrophe to a column of numbers - microsoft.public ...Hello, I need to add an apostrophe to each cell in a long column of numbers. I do not want to format them as text or format them as custom - our sys... Adding an apostrophe to a column of numbers - ExcelBanterExcel Discussion (Misc queries) ... Hello, I need to add an apostrophe to each cell in a long column of numbers. I do not ... One way. Change 9 to your column Sub ... Excel - Apostrophes, Numbers As Text, & Conditional Formatting ...numbers are still sorted before alphanumeric parts. "Text to columns" didn't solve the problem, but manually adding an apostrophe to the part numbers 7/19/2012 5:57:27 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 