EasyXLS http://forum.easyxls.com/ |
|
Value in Numeric Issue http://forum.easyxls.com/viewtopic.php?f=5&t=2284 |
Page 1 of 1 |
Author: | opingo [ Wed Sep 06, 2023 2:43 pm ] | ||||
Post subject: | Value in Numeric Issue | ||||
I have Following Query for EasyXLS for VB 6 I have a Value in Numeric which is already in formatted format. for Eg. "123.00" "12,345.00" "1,234,56789.00" If I am using format as "numeric" then it gives the Error while opening the Excel If I am using format as "automatic" then it does not gives the Error but it does not Show it Properly and it is Left alignment and it is String Format. I want the same to be Numeric Format in Excel. I am attaching the VB6 Source Code and Excel Files Can You Help me to correct the above Code or give the Sample code to do AutoFit of the all the column ? Thanking You, Bhavesh
|
Author: | opingo [ Wed Sep 06, 2023 2:44 pm ] | ||
Post subject: | Re: Value in Numeric Issue | ||
Error in "automatic" format Issue
|
Author: | daniela [ Wed Sep 13, 2023 7:26 am ] |
Post subject: | Re: Value in Numeric Issue |
The numbers must be entered with no additional formatting like 1,000.00, 1.000,00 or $1000. Also 1,234,56789.00 is not a number. |
Page 1 of 1 | All times are UTC - 4 hours |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |