You can use smart tag option to convert into date also,..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Mon/2012 09:39
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Number Stored text i need
Stored text i need convert to number
Dear all,
Any VBA code is there ?
regards
chandru
On Mon, Jan 2, 2012 at 10:46 AM, Kris krishnak...@gmail.com wrote:
Hi,
For Numbers,
Select each column on by one. Go to Data TextToColumns Next Next check
on General Finish
Dear all
Date also stored in texthow i convert to date pl advice
Regards
chandru
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Hi,
For Numbers,
Select each column on by one. Go to Data TextToColumns Next Next
check on General Finish.
For date, check Date Instead of General and select DMY Finish.
Kris
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Dear all,
Any VBA code is there ?
regards
chandru
On Mon, Jan 2, 2012 at 10:46 AM, Kris krishnak...@gmail.com wrote:
Hi,
For Numbers,
Select each column on by one. Go to Data TextToColumns Next Next
check on General Finish.
For date, check Date Instead of General and select DMY
Sub kTest()
Dim rngDate As Range
Dim rngNum As Range, i As Long
Set rngDate = Range(c3:c7688)
Set rngNum = Range(d3:e7688)
rngDate.TextToColumns Destination:=rngDate.Cells(1),
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote,