LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
CiaraF
 
Posts: n/a
Default How do you display 16 digit numbers in excel ? (it keeps convert.

I'm trying to display 16 digit numbers in excel but it keeps converting the
last digit to a zero. Is there a way to format the cells so the 16 digits are
displayed and can be used in a vlookup formula ?
 
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
Dont display the colors on the Cell ( Excel 2003 ) pigolampida New Users to Excel 1 February 1st 05 11:22 AM
Exporting numbers into Excel shedevel143 Excel Discussion (Misc queries) 1 December 11th 04 12:37 PM
Excel: To Display Formula in the cells Instead of Value [email protected] Excel Discussion (Misc queries) 1 December 10th 04 09:48 PM
Excel should be able to compute the MOD of large numbers. Gold Fish Excel Worksheet Functions 5 December 3rd 04 09:10 AM
column headings display as numbers JayT Setting up and Configuration of Excel 2 November 29th 04 06:51 PM


All times are GMT +1. The time now is 04:00 PM.

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

About Us

"It's about Microsoft Excel"