Excel Function

  • Thread starter Thread starter marie
  • Start date Start date
If it is 3 digit numbers

Format>Cells>Custom format >Type> 000

and then try typing the numbers

If this post helps click Yes
 
Hi,
Format, cells, custom format, type as many 0 as the total numbers including
the 0

i.e. 000123 you enter 000000
 
Hi,

You really need to tell us more about your data. Is it always a given
number of characters or is that variable. The formatting tricks that have
been recommended work for numbers of the same length. To handle variable
length number highlight your input range and choose Format, Cells, Number
tab, Text. Then enter the numbers.
 
Back
Top