View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default enter numeric value starting with zero

"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.


If you want to use the value as a number, you could format the individual
cell with a custom format with the correct number of digits of the form
000000 (for a 6-digit number).

Of course, that's a manual operation.

However, if the value is never uses a number (e.g. never used in an
arithmetic expression), it would be better to prefix the value with an
apostrophe or, if you have the benefit of forethought, format the cell as
Text before entering the value. If you are importing data, you can set the
column to be imported as Text instead of General.