Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
issue in data type in QTP
#5
Solved: 12 Years, 10 Months, 3 Weeks ago
Hi Galstar,

You have to change the data type of the datatable manually, here are steps,

1.Select the column of the datatable and right click
2. Click on Format and Custom Number--> Select Type as "0.00" and click on OK

There is another way to avoid this manually by entering the data as ="29.00" in the datatable cell. check the below code

Code:
DataTable.Value(2,1) = "="&chr(34)&"29.00"&chr(34)

Let me know if this works for you

Thanks
Vinod
Reply


Messages In This Thread
issue in data type in QTP - by galstar - 10-26-2010, 07:06 PM
RE: issue in data type in QTP - by MVChowdary - 10-26-2010, 07:43 PM
RE: issue in data type in QTP - by KVK - 10-27-2010, 10:12 AM
RE: issue in data type in QTP - by galstar - 10-27-2010, 10:39 AM
RE: issue in data type in QTP - by KVK - 10-27-2010, 11:23 AM
RE: issue in data type in QTP - by nandu - 11-19-2010, 07:31 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Different Type of Dropdown Selector zunebuggy 6 4,353 05-01-2018, 06:46 PM
Last Post: zunebuggy
  On Saving Script in QTP 11 my Global Data Sheet data is removed M Adnan Iftikhar 0 2,479 06-02-2015, 09:19 PM
Last Post: M Adnan Iftikhar
  cannot use the type method on object and submit is not working jove1776 5 9,772 01-27-2015, 10:08 PM
Last Post: Parke
  How to import .xlsx file type to QTP qtped 3 7,269 03-27-2014, 01:33 PM
Last Post: Ankur
  type mismatch error in QTP QAlearningQTP 1 7,548 02-04-2014, 08:14 AM
Last Post: QAlearningQTP

Forum Jump:


Users browsing this thread: 1 Guest(s)