Re: $$Excel-Macros$$ Meaning of "Value 2"

Got it ! Thanks a lot Regard, Prafull Jadhav. 9920553518 On 24-Oct-2013 1:37 PM, "xlstime" wrote: > > sub rr() > range("a1").value =date > range("a2").value2=date > end sub > > > . > > Enjoy > Team XLS > > > > On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav > wrote: > >

Re: $$Excel-Macros$$ Meaning of "Value 2"

sub rr() range("a1").value =date range("a2").value2=date end sub . Enjoy Team XLS On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav wrote: > Thanks a lot Sir, > > Sir ..can you share one example for the same if possible. > > > > *Regards, > Prafull Jadhav > 9920553518*

Re: $$Excel-Macros$$ Meaning of "Value 2"

Thanks a lot Sir, Sir ..can you share one example for the same if possible. *Regards, Prafull Jadhav 9920553518* On Thu, Oct 24, 2013 at 1:00 PM, xlstime wrote: > Value2 always uses the same value that Excel uses. It does not truncate > decimal places ,Value2 gives you DateSerial so you kno

Re: $$Excel-Macros$$ Meaning of "Value 2"

Value2 always uses the same value that Excel uses. It does not truncate decimal places ,Value2 gives you DateSerial so you know exactly which day is meant. Same thing with currency and decimal/digit grouping symbols. . Enjoy Team XLS On Thu, Oct 24, 2013 at 9:29 AM, Pra