if i am having a date in a cell as 30/11/2005 but formatted in text, what's the procedure to change the same to date format as "30-Mar-2005"?
thks & regds!
via135
if i am having a date in a cell as 30/11/2005 but formatted in text, what's the procedure to change the same to date format as "30-Mar-2005"?
thks & regds!
via135
sorry! a small correction!
if i am having a date in a cell as 30/11/2005 but formatted in text, what's the procedure to change the same to date format as "30-Nov-2005"?
thks & regds!
via135
Originally Posted by via135
Hi
One way, with your date in A1, enter in B1
=--A1
Format>Cells>Number>Custom dd=mmm-yyyy
Regards
Roger Govier
via135 wrote:
> sorry! a small correction!
>
> if i am having a date in a cell as 30/11/2005 but formatted in text,
> what's the procedure to change the same to date format as
> "30-Nov-2005"?
>
> thks & regds!
>
> via135
>
>
>
>
>
>
> via135 Wrote:
>
>>if i am having a date in a cell as 30/11/2005 but formatted in text,
>>what's the procedure to change the same to date format as
>>"30-Mar-2005"?
>>
>>thks & regds!
>>
>>via135
>
>
>
Select cell and Data>Text to Columns>Next>Next
Data Format Type>Date DMY Finish.
Gord Dibben Excel MVP
On Fri, 23 Dec 2005 12:10:43 -0600, via135
<[email protected]> wrote:
>
>sorry! a small correction!
>
>if i am having a date in a cell as 30/11/2005 but formatted in text,
>what's the procedure to change the same to date format as
>"30-Nov-2005"?
>
>thks & regds!
>
>via135
>
>
>
>
>
>
>via135 Wrote:
>> if i am having a date in a cell as 30/11/2005 but formatted in text,
>> what's the procedure to change the same to date format as
>> "30-Mar-2005"?
>>
>> thks & regds!
>>
>> via135
One fairly easy solution, select the cell/column with the text dates,
do data>text to column, click next twice and under column data format
select date and from the dropdown select DMY and click finish, this will
change it to a numerical date and then you can just use custom format like
dd-mmm-yyyy
--
Regards,
Peo Sjoblom
"via135" <[email protected]> wrote in
message news:[email protected]...
>
> sorry! a small correction!
>
> if i am having a date in a cell as 30/11/2005 but formatted in text,
> what's the procedure to change the same to date format as
> "30-Nov-2005"?
>
> thks & regds!
>
> via135
>
>
>
>
>
>
> via135 Wrote:
> > if i am having a date in a cell as 30/11/2005 but formatted in text,
> > what's the procedure to change the same to date format as
> > "30-Mar-2005"?
> >
> > thks & regds!
> >
> > via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=495816
>
Hi Roger,
that would work if the OP is using UK regional settings but not if he uses
US since it will return a value error
--
Regards,
Peo Sjoblom
"Roger Govier" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> One way, with your date in A1, enter in B1
> =--A1
> Format>Cells>Number>Custom dd=mmm-yyyy
>
> Regards
>
> Roger Govier
>
>
> via135 wrote:
> > sorry! a small correction!
> >
> > if i am having a date in a cell as 30/11/2005 but formatted in text,
> > what's the procedure to change the same to date format as
> > "30-Nov-2005"?
> >
> > thks & regds!
> >
> > via135
> >
> >
> >
> >
> >
> >
> > via135 Wrote:
> >
> >>if i am having a date in a cell as 30/11/2005 but formatted in text,
> >>what's the procedure to change the same to date format as
> >>"30-Mar-2005"?
> >>
> >>thks & regds!
> >>
> >>via135
> >
> >
> >
if your date is in cell A1 in the next cell type =datevalue(A1), then go to
format-->cell--> date-->choose type 14-Mar-2001 ( it is the last item).
Hope it works.
happy Holidays!
"Gord Dibben" wrote:
> Select cell and Data>Text to Columns>Next>Next
>
> Data Format Type>Date DMY Finish.
>
>
> Gord Dibben Excel MVP
>
> On Fri, 23 Dec 2005 12:10:43 -0600, via135
> <[email protected]> wrote:
>
> >
> >sorry! a small correction!
> >
> >if i am having a date in a cell as 30/11/2005 but formatted in text,
> >what's the procedure to change the same to date format as
> >"30-Nov-2005"?
> >
> >thks & regds!
> >
> >via135
> >
> >
> >
> >
> >
> >
> >via135 Wrote:
> >> if i am having a date in a cell as 30/11/2005 but formatted in text,
> >> what's the procedure to change the same to date format as
> >> "30-Mar-2005"?
> >>
> >> thks & regds!
> >>
> >> via135
>
This won't work if the OP is using US regional settings which I suspect
he/she might do
--
Regards,
Peo Sjoblom
"Nikki" <[email protected]> wrote in message
news:[email protected]...
> if your date is in cell A1 in the next cell type =datevalue(A1), then go
to
> format-->cell--> date-->choose type 14-Mar-2001 ( it is the last item).
>
> Hope it works.
> happy Holidays!
>
> "Gord Dibben" wrote:
>
> > Select cell and Data>Text to Columns>Next>Next
> >
> > Data Format Type>Date DMY Finish.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Fri, 23 Dec 2005 12:10:43 -0600, via135
> > <[email protected]> wrote:
> >
> > >
> > >sorry! a small correction!
> > >
> > >if i am having a date in a cell as 30/11/2005 but formatted in text,
> > >what's the procedure to change the same to date format as
> > >"30-Nov-2005"?
> > >
> > >thks & regds!
> > >
> > >via135
> > >
> > >
> > >
> > >
> > >
> > >
> > >via135 Wrote:
> > >> if i am having a date in a cell as 30/11/2005 but formatted in text,
> > >> what's the procedure to change the same to date format as
> > >> "30-Mar-2005"?
> > >>
> > >> thks & regds!
> > >>
> > >> via135
> >
hi
thks everyone for ur immediate response!
via135
Originally Posted by Peo Sjoblom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks