Microsoft Excel

  Revi 10:30 23 Sep 2003

Whenever I type a number beginning with a zero in a cell and then press Enter the number gets registered in the cell without the zero. How to format the cell so that the zero stays? Please help.

  Revi 10:40 23 Sep 2003


  DieSse 10:44 23 Sep 2003

Numbers don't begin with zeroes - but text which has consists of numbers or has numbers in it (such as serial/reference numbers) can do - so format the cell for text.

  Revi 10:47 23 Sep 2003

Thanks, but under format I don't find any alternative which allows me to format as text. I know it is there somewhere but would you please tell me where to find it?

  MAJ 10:50 23 Sep 2003

You can enter 04, 004, 0004 etc., but I'm darned if I can remember it at the moment. Where's VoG when you need him?

  Revi 10:50 23 Sep 2003

Sorry for the trouble. I found it, many thanks. Now all's okay.

  tbh72 11:43 23 Sep 2003

You can also type a ' "Apostrophy"..... ;-) I think that's how it's spelt.

  Alan2 13:21 23 Sep 2003

Using Excel 2002 the following works:-

Select cell(s) in question then go to format/cells/custom

in the box under type enter say 000.00 and click OK.

When you then enter say 7 in one of the cells it will be displayed as 007.00


  MAJ 13:38 23 Sep 2003

That's the one I was trying to think of, Alan2, cheers. If you enter 00 in that "Type" box, you will get 01,02,03,04.....09,10,11 and so on. The problem with using Text or the apostrophe is that you can't use them in calculations.

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

Elsewhere on IDG sites

Nintendo Labo review: Hands-on

The best smart speaker: Apple HomePod vs Google Home vs Amazon Echo

Les meilleurs SSD (2018)