P padhi Jan 21, 2010 #1 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
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 Jan 21, 2010 #2 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 Click to expand... 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.
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 Click to expand... 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.
