How to Change Text Format to number Format

[panipat1990]

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..

[Chanty4u]

try

=Num(urfield)

[trdandamudi]

Use Num() function...

[m_woolf]

Your Excel data says: 1,82,201.00

[panipat1990]

i already used num(ABC) function but result not found.

[sunny_talwar]

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$);

[alexpanjhc]

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

[panipat1990]

Hi Sunny,

When i select 182,201.0,From ABC List Box... Then It show 1,82,201.00 In ABC1 List Box..

[sunny_talwar]

What do you want it to show?

[HirisH_V7]

Hi,

Check this,

Num(PurgeChar(ABC,','),'##,##,##,##,##,##0.0') As ABC1

HTH,

Hirish