Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement. i want to change text format to number format.. Here i am attaching Excel and qvw. all are changing from text to number format except one..1,182,201.00 Please Help me..
try
=Num(urfield)
Use Num() function...
Your Excel data says: 1,82,201.00
i already used num(ABC) function but result not found.
Try this:
Tab:
Load
ABC,
Num(Num#(ABC, '##,##,##,##,##,##0.00'), '##,##,##,##,##,##0.00') As ABC1
From
[LB07_20160516_141128.xls]
(biff, embedded labels, table is Sheet1$);
You do not have 1,182,201.00 at all in your excel. You have two 182,201.00 one is formatted as is, the other is formatted as 1,82,201.00
Hi Sunny,
When i select 182,201.0,From ABC List Box... Then It show 1,82,201.00 In ABC1 List Box..
What do you want it to show?
Hi,
Check this,
Num(PurgeChar(ABC,','),'##,##,##,##,##,##0.0') As ABC1
HTH,
Hirish