Numbers on Spreadsheet

  Issy 13:49 30 Oct 2005
Locked

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 2005

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 2005

Many thanks for the quick response

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?