|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
February 27th, 2004, 11:37 PM
|
|||
|
|||
|
Number Format
Hai, I am Ramesh,
When I was developing a frontend in vb for an Excel file. I found that, number such as 0001 is automatically truncated to 1. Can any one help me to solve my problem (excel auto truncation of number). Thanks, Ramesh Krishnan R
|
|
#2
March 1st, 2004, 01:58 PM
|
|||
|
|||
|
The only way to stop that is for force execl to see it as a string and not a number (put a ' in form of the value), Problem with that is that you can't use it in any calculations.
You could also try and format the number with leading zeros format (Number, "0000") S-
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Number Format |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
