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,
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 xlst...@gmail.com wrote:
Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you
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 prafulltjad...@gmail.comwrote:
Thanks a lot Sir,
Sir ..can you share one example for the same if possible.
*Regards,
Prafull Jadhav
Got it !
Thanks a lot
Regard,
Prafull Jadhav.
9920553518
On 24-Oct-2013 1:37 PM, xlstime xlst...@gmail.com 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
Hi Team,
Need your help to sort (In one Short) Rows in Ascending order without using
Macro or ASAP Utilites. Pls help.
Rgds,
Prabhakar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
hope i understand ur requirement
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 2:33 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
Need your help to sort (In one Short) Rows in Ascending order without
using Macro or ASAP Utilites. Pls help.
Rgds,
For Unhiding the Columns, Select the entire columns(or Ctrl+Space) then
click on right click button using Mouse or right click button then Click U
On Wed, Oct 23, 2013 at 4:40 PM, Radhe Sham radhe2...@gmail.com wrote:
Hi Group,
My system got upgraded with Windows 7 Professional.
In terms