Prev: Can Excel 2007 open a numbers file?
Next: Pivot Table - Just show Value in Summery no Calculation
From: padhi on 21 Jan 2010 06:58 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
From: Yanick on 21 Jan 2010 07:03 On Jan 21, 6:58 am, padhi <pa...(a)discussions.microsoft.com> 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.
|
Pages: 1 Prev: Can Excel 2007 open a numbers file? Next: Pivot Table - Just show Value in Summery no Calculation |