Microsoft Excel

  Revi 10:30 23 Sep 03
Locked

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 03

^^^^

  DieSse 10:44 23 Sep 03

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 03

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 03

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 03

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

  tbh72 11:43 23 Sep 03

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

  Alan2 13:21 23 Sep 03

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

Alan

  MAJ 13:38 23 Sep 03

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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…