Prev: cannot open Excel (.xls) attachments in Outlook
Next: Excel not opening documents correctly
From: Keoni2008 on 28 May 2010 18:05
I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
"0/00/00 and 00/00/0000". How can I quick fix this problem into just one
format for all like this way "00/00/00"? I tried using the formula and it
did not help at all and the other way was for me to use "format cells,
category-date, type-00/00/00”. Then, after I have to manually go into each
cell and double click it and that the only way it will format it. Please
help there must be an easier way to fix this problem.
From: Bob Phillips on 28 May 2010 18:31
Try Data>Text To Columns and tab through to the third section where you can
specify dates.

--

HTH

Bob

"Keoni2008" <Keoni2008(a)discussions.microsoft.com> wrote in message
news:7320FF96-8EE6-496A-8E70-FCB585ECCD92(a)microsoft.com...
>I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
> "0/00/00 and 00/00/0000". How can I quick fix this problem into just one
> format for all like this way "00/00/00"? I tried using the formula and it
> did not help at all and the other way was for me to use "format cells,
> category-date, type-00/00/00". Then, after I have to manually go into
> each
> cell and double click it and that the only way it will format it. Please
> help there must be an easier way to fix this problem.


From: Don Guillett on 28 May 2010 18:31

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Keoni2008" <Keoni2008(a)discussions.microsoft.com> wrote in message
news:7320FF96-8EE6-496A-8E70-FCB585ECCD92(a)microsoft.com...
>I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
> "0/00/00 and 00/00/0000". How can I quick fix this problem into just one
> format for all like this way "00/00/00"? I tried using the formula and it
> did not help at all and the other way was for me to use "format cells,
> category-date, type-00/00/00”. Then, after I have to manually go into
> each
> cell and double click it and that the only way it will format it. Please
> help there must be an easier way to fix this problem.

From: Tamer Paksoy on 28 May 2010 19:53
Keoni,
Once you format one of the cells and if you are happy, use format painter
for the rest. I should work.
Tamer Paksoy

"Keoni2008" wrote:

> I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
> "0/00/00 and 00/00/0000". How can I quick fix this problem into just one
> format for all like this way "00/00/00"? I tried using the formula and it
> did not help at all and the other way was for me to use "format cells,
> category-date, type-00/00/00”. Then, after I have to manually go into each
> cell and double click it and that the only way it will format it. Please
> help there must be an easier way to fix this problem.
 | 
Pages: 1
Prev: cannot open Excel (.xls) attachments in Outlook
Next: Excel not opening documents correctly