View unanswered posts | View active topics
It is currently Tue Oct 08, 2024 8:41 am
|
Page 1 of 1
|
[ 3 posts ] |
|
Author |
Message |
opingo
Joined: Wed May 24, 2023 1:00 am Posts: 6
|
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
|
Wed Sep 06, 2023 2:43 pm |
|
|
opingo
Joined: Wed May 24, 2023 1:00 am Posts: 6
|
Re: Value in Numeric Issue
Error in "automatic" format Issue
|
Wed Sep 06, 2023 2:44 pm |
|
|
daniela
Joined: Fri Feb 03, 2006 12:23 pm Posts: 197 Location: Brasov, Romania
|
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.
_________________ EasyXLS Team .NET and Java library to read and write Excel files Facebook X Reddit LinkedIn
|
Wed Sep 13, 2023 7:26 am |
|
|
|
Page 1 of 1
|
[ 3 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|