Single Quote

Is there anyway to add a single quote to text in Excel. Example: '4' with out
it shifting to left. If so how and if it can be done is there a way to change
all that are now aligned left.

thanks!!
--
Jeffrey L. Lippard, A+ certified, CHDP certified

By default, text is aligned to the left (and '4 is text).
You can select the column and use Format/Cells/Alignment tab, click "Left
(Indent)" under horizontal alignment
Or you can simply click the left align tool on the formatting toolbar.
Bob Umlas
Excel MVP

"Kinjalip" <Kinjalip@discussions.microsoft.com> wrote in message
news:E5219AF0-4BEB-438F-A07F-FF87F9749C5E@microsoft.com...
> Is there anyway to add a single quote to text in Excel. Example: '4' with
out
> it shifting to left. If so how and if it can be done is there a way to
change
> all that are now aligned left.
>
> thanks!!
> --
> Jeffrey L. Lippard, A+ certified, CHDP certified

Bob,

When I attempted that, it still left me with 3' instead of '3'. Any ideas.

Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified


"Bob Umlas" wrote:

> By default, text is aligned to the left (and '4 is text).
> You can select the column and use Format/Cells/Alignment tab, click "Left
> (Indent)" under horizontal alignment
> Or you can simply click the left align tool on the formatting toolbar.
> Bob Umlas
> Excel MVP
>
> "Kinjalip" <Kinjalip@discussions.microsoft.com> wrote in message
> news:E5219AF0-4BEB-438F-A07F-FF87F9749C5E@microsoft.com...
> > Is there anyway to add a single quote to text in Excel. Example: '4' with
> out
> > it shifting to left. If so how and if it can be done is there a way to
> change
> > all that are now aligned left.
> >
> > thanks!!
> > --
> > Jeffrey L. Lippard, A+ certified, CHDP certified
>
>
>

"Kinjalip" <Kinjalip@discussions.microsoft.com> wrote

> When I attempted that, it still left me with 3' instead of '3'. Any ideas.

Type the initial ' twice.

--
Bob
http://www.kanyak.com

Thank you, this is exactly what I needed.

thanks again
--
Jeffrey L. Lippard, A+ certified, CHDP certified


"Opinicus" wrote:

> "Kinjalip" <Kinjalip@discussions.microsoft.com> wrote
>
> > When I attempted that, it still left me with 3' instead of '3'. Any ideas.
>
> Type the initial ' twice.
>
> --
> Bob
> http://www.kanyak.com
>
>
>