-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Dhanaventh
Message 1 in Discussion
Hi ,
If i have understood ur
question properly u could get the length of the string and precede it with Zeros
as
u require. Hope this works:)
Regards
Dan
-----Original Message-----
From: cool_vjy
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 5:34
PM
To: BDOTNET
Subject: formtting number in excel
spredsheet
New Message on BDOTNET
formtting
number in excel spredsheet
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: cool_vjy
Please help! I am opening a new window that contains an
Excel spreadsheet. The first column is a 13 digit identification
number. This number can start with a zero. My problem is that
when the data is displayed in the Excel window will display as
89615670000 when it should display as 0089615670000. I can get
the data to display correctly if I append a ' (upporstroph)
before the number. However the ' displays in the data
('0089615670000). How can I fix this? I have tried several
different things but nothing is working.
Thanks
vijay
dubey
View other groups in this
category.
**********************************************************Disclaimer***************************************************************************************************************************************
This is a transmission from Ivega Corporation Private Limited (Ivega), and may contain
information that is privileged and confidential. Ivega assumes no responsibility for
damages resulting from unauthorized access, disclosure, tampering or delayed receipt,
which could have occurred during transmission. If you have received this transmission
in error, please destroy it and notify the sender immediately.
Further, Ivega assumes no responsibility for any opinions, conclusions and other
information in this message that do not relate to its official business.
*********************************************************************************************************
****************************************************************************************************
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
