Is through the VBS links database, table, and then to Excel in, only the 50 in the database is 50.0, I want it to hit the Excel sheet that is set before excrl data formats, help ah
CodePudding user response:
Don't sink... Please pull out
CodePudding user response:
XlSheet. Range (" A1 "). NumberFormatLocal="G/common format"
NumberFormatLocal="0.00" 'set number to two decimal places
NumberFormatLocal="@" 'set Numbers to text
A1 is you to set up the format of the cell, according to the need to set the value of NumberFormatLocal
CodePudding user response:
The
reference 3 floor response: VB amateurs xlSheet. Range (" A1 "). NumberFormatLocal="G/common format thank you bosses, reliable, has good, CodePudding user response:
reference 4 floor weixin_44186146 response: Quote: reference 3 floor response: VB amateurs xlSheet. Range (" A1 "). NumberFormatLocal="G/common format" thank you bosses, reliable, has good, CodePudding user response:
refer to fifth floor response: VB amateurs Quote: refer to 4th floor weixin_44186146 response: Quote: refer to the third floor response: VB amateurs xlSheet. Range (" A1 "). NumberFormatLocal="G/common format" thank you bosses, reliable, has good, can again ask you a question, you found that the problem is not now, because the inside of the table data type is a decimal type, so wrong, can you help me? Thank you! CodePudding user response:
refer to 6th floor weixin_44186146 response: Quote: refer to the 5 floor response: VB amateurs Quote: refer to 4th floor weixin_44186146 response: Quote: refer to the third floor response: VB amateurs xlSheet. Range (" A1 "). NumberFormatLocal="G/common format" thank you bosses, reliable, has good, can again ask you a question, you found that the problem is not now, because the inside of the table data type is a decimal type, so wrong, can you help me? Thank you! 
