thanks vaibhavji
On Sat, Feb 28, 2015 at 11:35 AM, Pol Ktk wrote:
> very nice & easy solution
>
> On 23 February 2015 at 20:36, Vaibhav Joshi wrote:
>
>> Convert all date in same format:
>>
>> While receiving data from different sources many time it happens that
>> data received is not in same
very nice & easy solution
On 23 February 2015 at 20:36, Vaibhav Joshi wrote:
> Convert all date in same format:
>
> While receiving data from different sources many time it happens that
> data received is not in same format due to various reason.
>
> One of the tedious activity is to transformi
type ctr + ; in excel cell, format which you get is default date format...
On Fri, Feb 27, 2015 at 6:33 PM, amar takale wrote:
> I have no access to see.Pls see print shot.
>
> On Fri, Feb 27, 2015 at 6:26 PM, Vaibhav Joshi wrote:
>
>> what default date format of your machine?
>>
>>
>> On Fri,
what default date format of your machine?
On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
> PFA
>
> On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
>
>> Dear Sourab
>>
>> How to do it in one attempt only *1 in column B.When I extract date from
>> our database software then paste it one
PFA
On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
> Dear Sourab
>
> How to do it in one attempt only *1 in column B.When I extract date from
> our database software then paste it one excel then I do *1 to all date but
> answer is Value,why?
>
> Regards
> Amar
>
> On Thu, Feb 26, 2015 at 9:
Dear Sourab
How to do it in one attempt only *1 in column B.When I extract date from
our database software then paste it one excel then I do *1 to all date but
answer is Value,why?
Regards
Amar
On Thu, Feb 26, 2015 at 9:25 PM, Sourabh Salgotra
wrote:
> THANKS FOR GREAT TRICK VAIBHAV
>
> WORKIN
Amar
I am not getting any error...see screenshot below..
in your case i guess you have set default date format to m/d/ydue to which
you are getting error...
[image: Inline image 1]
On Thu, Feb 26, 2015 at 12:01 PM, amar takale wrote:
> pls look sheet where sheetl1 not change as per you say
THANKS FOR GREAT TRICK VAIBHAV
WORKING PERFECTLY
On Thu, Feb 26, 2015 at 12:01 PM, amar takale wrote:
> pls look sheet where sheetl1 not change as per you saying. Pls explain me
>
> On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote:
>
>> Dear Amar
>>
>> Data in col b date only, you just n
pls look sheet where sheetl1 not change as per you saying. Pls explain me
On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote:
> Dear Amar
>
> Data in col b date only, you just need to change format of col B to date
> by selecting col b & pressing ctr+shift+3
>
> Cheers!!
>
> On Wed, Feb 25,
Dear Amar
Data in col b date only, you just need to change format of col B to date by
selecting col b & pressing ctr+shift+3
Cheers!!
On Wed, Feb 25, 2015 at 5:11 PM, amar takale wrote:
> Dear Vabs bro thanks very much for this knowledgeable trick.
> I discuss here attached file for date issue
Dear Vabs bro thanks very much for this knowledgeable trick.
I discuss here attached file for date issue not converted in same format as
per your trick,why? i always use text to column operation trick for same
format.
On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi wrote:
> Cheers Chandan & Gaura
Cheers Chandan & Gaurav
On Tue, Feb 24, 2015 at 11:57 AM, Gaurav Devrani
wrote:
> Superb Vaibhav. Thanks for sharing this with us.
>
> Regards
> Gaurav Devrani
>
> On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht
> wrote:
>
>> Hi.
>>
>> Very nice...
>>
>> Thankx & Rgds,
>>
>> Chandra Singh Bisht
Superb Vaibhav. Thanks for sharing this with us.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht wrote:
> Hi.
>
> Very nice...
>
> Thankx & Rgds,
>
> Chandra Singh Bisht
>
>
>
> On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
>
>> Convert all date in same format:
>
Hi.
Very nice...
Thankx & Rgds,
Chandra Singh Bisht
On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
> Convert all date in same format:
>
> While receiving data from different sources many time it happens that
> data received is not in same format due to various reason.
>
> One of the
Convert all date in same format:
While receiving data from different sources many time it happens that data
received is not in same format due to various reason.
One of the tedious activity is to transforming data to same format.
I will share very good technique to convert all dates to same for
Dear Members,
Sometimes you have many questions in mind like :
How to know the cell protection status - Locked or Unlocked ?
How to know the width of the cell ?
How to know alignment of cell ?
How to identify row & Col number of cell ?
How to know the worksheet name, filename & full path of give
Hi All,
To copy paste for all the cells. Lets say you have the data in A3 and you
want to copy to C3:C4 cells.Using mouse to select all the cells is
little bit difficult.
Now you can do the same with below easy steps.
1. Select B3.
2. Then *Ctrl+C* to copy the data
3. Click once in
Hi,
Here's my contribution
If you have N/A or any other data which is commonly filled in various cells
of a work book and you would like to replace all of them with a blank or any
other character, say, Y.
1. Press Ctrl + F
2. Type the text which you wish to find
3. Click on Replace
18 matches
Mail list logo
