Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wallis
 
Posts: n/a
Default Appears like 7,07046E+16, should be 70704610008791736


  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

You're limited to 15 digit precision in XL. If it's not a
number, preformat the cell as text.

HTH
Jason
Atlanta, GA

-----Original Message-----

.

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
7,07046E+16 appears when i should be 70704610008791736 Birger Excel Discussion (Misc queries) 1 January 21st 05 01:48 PM
Chart Label wraps on the same line. "Wavelenght [nm]" appears as. rog Charts and Charting in Excel 1 December 15th 04 08:10 PM
Wrapped text appears as xxxxxx RegV Excel Discussion (Misc queries) 0 December 15th 04 03:43 PM
Excel File Appears Blank Tony C. Excel Discussion (Misc queries) 2 December 7th 04 12:59 AM
Lookup the latest date in a range so it appears as my result FBB Excel Discussion (Misc queries) 1 December 4th 04 03:50 AM


All times are GMT +1. The time now is 12:17 PM.

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"