Prev: Count of cells since first purchase
Next: Formula to average last 25 entries in a column?
From: zyus on 1 Jun 2010 04:28
When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it
as value in the cell
From: Ms-Exl-Learner on 1 Jun 2010 04:44
Format the cell as Text.
Select the Range>>Do Right Click>>Format Cells>>Number>>Category>>Text and
give ok. Now input your leading zero value in the text formatted range.

But the Values are not treated as real numbers and it is considered as Text
Values.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"zyus" wrote:

> When i use formatting cell custom with 0000 i manage to add leading zero but
> the problem is the leading zero only as appearance. Is it possible to make it
> as value in the cell
From: Gord Dibben on 1 Jun 2010 10:28
2 options.

You want value of 0123 in A1

Precede 0123 with an apostrophe.

OR in an adjacent cell =TEXT(A1,"0000")


Gord Dibben MS Excel MVP

On Tue, 1 Jun 2010 01:28:05 -0700, zyus <zyus(a)discussions.microsoft.com>
wrote:

>When i use formatting cell custom with 0000 i manage to add leading zero but
>the problem is the leading zero only as appearance. Is it possible to make it
>as value in the cell

 | 
Pages: 1
Prev: Count of cells since first purchase
Next: Formula to average last 25 entries in a column?