Prev: 2 excel workbooks open up from 1 file; named :1 and :2 - why?
Next: Last day of last month
From: Fred Smith on 12 Mar 2010 16:15
Glad to help. Thanks for the feedback.

Fred

"Denise C." <DeniseC(a)discussions.microsoft.com> wrote in message
news:2EDA2A70-0D47-4A6C-8F9A-83F82CA66840(a)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....

First  |  Prev  | 
Pages: 1 2
Prev: 2 excel workbooks open up from 1 file; named :1 and :2 - why?
Next: Last day of last month