opy an empty cell, then highlight the cells (or entire
>>>>> column(s)) containing your textual date/times, then Paste Special>Add.
>>>>> The
>>>>> add operation forces Excel to convert the date/time.
>>>>>
>>>>> ** **
>>>>>
>
ath
>>>> operation like *=A3+0* or *=A3*1* or *=--A3*. You could if desired
>>>> copy those cells to another location using Paste Special>Values.****
>>>>
>>>> ** **
>>>>
>>>> I'll just add that if the data is being im
location using Paste Special>Values.
>>>
>>> ** **
>>>
>>> I'll just add that if the data is being imported from a text file, make
>>> sure you highlight the column containing date/times during import and
>>> specify the correct date format for that column
s during import and
>> specify the correct date format for that column; it may avoid the whole
>> problem.
>>
>> ** **
>>
>> Asa****
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Beha
problem.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar
> *Sent:* Wednesday, October 05, 2011 9:50 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Exc
Hi B.N Chetan kumar,
Try this...
=--SUBSTITUTE(A3," ","-")
Or
=IF(ISERR(--SUBSTITUTE(A3," ","-")),"",--SUBSTITUTE(A3," ","-"))
Hope that helps!
---
Ms.Exl.Learner
---
On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar <
chetankumar1...@gmail.com> wrote
, 2011 9:50 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a help -very urgent
Hi All,
I have attached file where i get some data in text format. I need convert to
date and time format.
Currently using text to coloumn method which is manually pocess. As sheet
co
Thanks SAM, for prompt response...currently i using the same option to
convert date and text to columns option for time...
Due to data size...it is taking more time.
Regards
Chethan Kumar BN
On Thu, Oct 6, 2011 at 10:43 AM, Sam Mathai Chacko wrote:
> =DATEVALUE(LEFT(A3,2)&"/"&MID(A3,FIND(" ",A3
=DATEVALUE(LEFT(A3,2)&"/"&MID(A3,FIND(" ",A3)+1,3)&"/"&RIGHT(A3,4))
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar <
chetankumar1...@gmail.com> wrote:
> Hi All,
>
> I have attached file where i get some data in text format. I need convert
> to date and time f
Hi All,
I have attached file where i get some data in text format. I need convert to
date and time format.
Currently using text to coloumn method which is manually pocess. As sheet
count is high in a workbook, these is very painful work to do in month end.
Kindly request your help to very painf
10 matches
Mail list logo
