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 wrote:
Hi,
For Numbers,
Select each column on by one. Go to Data > TextToColumns > Next > Next check
on General > Finish.
For
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
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, ConsecutiveD
Dear all,
Any VBA code is there ?
regards
chandru
On Mon, Jan 2, 2012 at 10:46 AM, Kris 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 > Finish.
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. Poo
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 Advi
