how to start with 0 in a cell in excel

P

padhi

whenever I try to enter 0 with some nos 0 is not coming in starting of
number.I want to put a value in a cell with 0 starting number
 
Y

Yanick

whenever I try to enter 0 with some nos 0 is not coming in starting of
number.I want to put a value in a cell with 0 starting number

By definition, a number can't begin with a 0. You need to change the
cell format for TEXT to be able to do it or add a ' (single quote) as
first caractere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top