Numbers on Spreadsheet

  Issy 13:49 30 Oct 05

Why is it when trying to enter a 20 digit number on a Works Suite 2003 spreadsheet it keeps showing the last digit as zero although I have entered it correctly?

  VoG II 13:56 30 Oct 05

Because the spreadsheet does not store the number with the precision required for a 20-digit number.

If you do not need to do calculations on this number, precede it with a ' to store it as a text value.

  Issy 14:21 30 Oct 05

Many thanks for the quick response

This thread is now locked and can not be replied to.

How to watch Surface PC live stream | Surface PC release date, price, spec rumours: All-in-one…

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

Apple's event invitations decoded: A look back at 16 of Apple's most cryptic invites | Clues in…