https://community.sap.com/t5/application-development-and-automation-discussions/how-to-extract-numeric-value-instead-of-text-from-guitablecontrol-vb-script/m-p/475428#M15446 <P>I use visual basic scripting from Excel to automatize some tasks in SAP.</P><P>But many times I face this problem when dealing with GuiTableControls: The numbers and dates are formatted as text, not values. That causes me a lot of problems when different users have different settings (commas and points as decimal separator, for example).</P><P>Is there a function like getcellvalue in GuiCtrlGridView??</P><P>A work around would be to access the User Profile in System/User Profile/Own Data/Defaults to get the default format for the current user, and create a function to convert the text to a value depending on the default format.</P><P>I have been trying for quite some time, but I can't find or figure out how to do this. Can someone give me a hint?</P><P>Thank you!</P><P>Pablo</P> Tue, 11 Apr 2017 03:37:33 GMT Former Member 2017-04-11T03:37:33Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-extract-numeric-value-instead-of-text-from-guitablecontrol-vb-script/m-p/475428#M15446 <P>I use visual basic scripting from Excel to automatize some tasks in SAP.</P><P>But many times I face this problem when dealing with GuiTableControls: The numbers and dates are formatted as text, not values. That causes me a lot of problems when different users have different settings (commas and points as decimal separator, for example).</P><P>Is there a function like getcellvalue in GuiCtrlGridView??</P><P>A work around would be to access the User Profile in System/User Profile/Own Data/Defaults to get the default format for the current user, and create a function to convert the text to a value depending on the default format.</P><P>I have been trying for quite some time, but I can't find or figure out how to do this. Can someone give me a hint?</P><P>Thank you!</P><P>Pablo</P> Tue, 11 Apr 2017 03:37:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-extract-numeric-value-instead-of-text-from-guitablecontrol-vb-script/m-p/475428#M15446 Former Member 2017-04-11T03:37:33Z