Formatting Cells Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Corbin - 19 May 2008 19:25 GMT

Hi

I am having troubles with formatting cells in EXCEL 2003.

I have a column of many hundreds of rows lthat contain data like
this:

01Jan12

on fist glance this looks like a date but it really is not.

EXCEL on the other automatically assumes it is a date and formats as
such.

2001-Jan-12

I have tried formatting as text, General and even experimented with
custom formats to no avail.

In the same column I have

03Mar1543

Which is dispolayed exactly as is.

How can I get EXCEL to simply display data like 01Jan12 exactly as is?

Reply to this Message

Gary''s Student - 19 May 2008 20:38 GMT

You must format the cell as Text BEFORE typing any information into it. An
alternative approach is to start the typing with an apostrophe (single
quote). This tells Excel that the data is text and not to make any
adjustments.

The single quote does not actually appear in the cell, but is visible in the
formula bar.

Signature

Gary''s Student - gsnu2007i

> Hi
>
[quoted text clipped - 22 lines]
>
> How can I get EXCEL to simply display data like 01Jan12 exactly as is?

Reply to this Message

John Corbin - 19 May 2008 21:08 GMT

On May 19, 3:38 pm, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:

> You must format the cell as Text BEFORE typing any information into it. An
> alternative approach is to start the typing with an apostrophe (single
[quoted text clipped - 34 lines]
>
> - Show quoted text -

OK... Thanks

I am cutting and pasting from a site into a worksheet...

Formatting as text before hand does not work.

is there a custom format that I can set up ?

Reply to this Message

one third - 21 May 2008 17:05 GMT

> Hi
>
[quoted text clipped - 22 lines]
>
> How can I get EXCEL to simply display data like 01Jan12 exactly as is?

Try formating the cells that you will be pasting into as text first,
then paste into them using 'Paste Special... > Values'

Reply to this Message