enter numeric value starting with zero
Another possibility is to custom format the cell with format code e.g.
"000000". This works if you want to display numbers with a fixed length, in
my example 6 characters. E.g. 123 will be displayed like 000123, 4567 like
004567, etc.
Regards,
Stefi
€˛Ms-Exl-Learner€¯ ezt Ć*rta:
Just format the cell as Text and enter try to enter the value
Select the range and do Right Click and select Format
CellsNumberCategoryText and give ok.
Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.
If this post helps, Click Yes!
--------------------
(MS-Exl-Learner)
--------------------
"Prasoon" wrote:
On assigning numeric value starting with zero , the value is shown without
zero.
I want to show zero in front of the assign value only in those values where
zero is given.
|