View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default enter numeric value starting with zero

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.