View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bumble78 bumble78 is offline
external usenet poster
 
Posts: 1
Default 20 digit wont stop ending in zeros


I am trying to enter a 20 digit number into one cell but it keeps
turning the last 5 numbers to zeros. I have tried text, number,
currency, custom. Is there some trick that I should know excel just
hate me?

Thanks for any help,
Joe


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=572883