ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to start with 0 in a cell in excel (https://www.excelbanter.com/excel-discussion-misc-queries/253981-how-start-0-cell-excel.html)

padhi

how to start with 0 in a cell in excel
 
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

Yanick

how to start with 0 in a cell in excel
 
On Jan 21, 6:58*am, padhi wrote:
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.


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com