TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mike
NA
25
0
NamedRange.NumberFormat property (excel interop)
Jul 1 2010 10:37 AM
Hello,
I am having to hand craft an excel spreadsheet using COM interop - it is reasonably tedious but i have completed my work, with the exception of a single issue. I have data that gets put in to a cell... this data is text. My issue is with the NumberFormat property. I cannot get it to display the data as text. My input data is;
REF1456734TXT - (gets formatted in the cell fine)
28543500109 - (gets formatted incorrectly)
I would like them to look exactly as above. Annoyingly, if i use NumberFormat = "@", or NumberFormat = "General" It shows like this;
2.85435E+11
If i use NumberFormat = "#,##0" it displays as 285,435,001.09. I just want it to appear as textual... no formatting at all. Can this be done?
Any help would be greatly appriciated!
Reply
Answers (
0
)
Excel Exception from HRESULT: 0x800AC472
Interoperablity issue acoross machine in the same network