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

Attachments:
File comment: "numeric" format Issue - 2
Numeric2.jpg
Numeric2.jpg [ 33.46 KiB | Viewed 41776 times ]
File comment: "numeric" format Issue - 1
Numeric.jpg
Numeric.jpg [ 23.92 KiB | Viewed 41776 times ]
Numeric Issue.zip [12.73 KiB]
Downloaded 2838 times

Author:  opingo [ Wed Sep 06, 2023 2:44 pm ]
Post subject:  Re: Value in Numeric Issue

Error in "automatic" format Issue

Attachments:
File comment: "automatic" format Issue
Automatic.jpg
Automatic.jpg [ 37.95 KiB | Viewed 41775 times ]

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/