View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default How do I stop last number from changing to a 0 in excel


Excel will only display up to 15 significant digits. So anything beyond
the 15th number will display as a zero. You can either set it up to
display in scientific notation or if you will not be using the numbers
for any math then simply put an apostrophe (') in front of the number
to display it as text.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=499889