Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Displaying big numbers WITHOUT scientific notations

I'm using C#, and I want my report to show id numbers correctly, without E
(scientific notation). How can I do that? In excel I just choose number, and
it works.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 137
Default Displaying big numbers WITHOUT scientific notations

On Feb 8, 8:28 am, G. H. <G. wrote:
I'm using C#, and I want my report to show id numbers correctly, without E
(scientific notation). How can I do that? In excel I just choose number, and
it works.



GH,

Have you tried

Range("A1").NumberFormat = "0"



Greg

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Displaying big numbers WITHOUT scientific notations

Yeah, doesn't work. So far I'm using a "'" before the number, but I'm not
sure it's going to cut it.

"Greg Glynn" wrote:

On Feb 8, 8:28 am, G. H. <G. wrote:
I'm using C#, and I want my report to show id numbers correctly, without E
(scientific notation). How can I do that? In excel I just choose number, and
it works.



GH,

Have you tried

Range("A1").NumberFormat = "0"



Greg


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
text converted to scientific notations jubu Excel Discussion (Misc queries) 4 November 18th 08 09:20 PM
Automatic conversion to scientific numbers cew47 Excel Discussion (Misc queries) 2 July 17th 07 07:40 PM
Supress Scientific Numbers?? Sam New Users to Excel 2 August 11th 05 08:40 PM
csv converting numbers to scientific format JR Excel Discussion (Misc queries) 7 June 16th 05 12:13 AM
importing large numbers to vb results in the numbers being formatted to scientific molly Excel Programming 2 February 3rd 04 02:27 PM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"