Thread: the end of long numbers turn to 0s how do i stop that?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default the end of long numbers turn to 0s how do i stop that?
Shawna

Excel cares about only the first 15 significant digits.

Precede the 15 digits with an apostrophe to show as text.

Excel will not change 15 to zeros.


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 10:08:06 -0800, Shawna
wrote:

5489 4861 3481 5448 8461 turns to
5489 4861 3481 5440 0000 how do i maintain those numbers?

Reply With QuoteReply With Quote