Excel Numbers
 

How do you keep zeros in front of numbers in Excel

Excel Numbers
 

Format the cells as text.

Dave
--
Brevity is the soul of wit.


"Excelinator" wrote:

How do you keep zeros in front of numbers in Excel

Excel Numbers
 

Or, format as Special, and type in as many zeros as you want characters.
(i.e. - need a ten digit number, enter 10 0's)

"Dave F" wrote:

Format the cells as text.

Dave
--
Brevity is the soul of wit.


"Excelinator" wrote:

How do you keep zeros in front of numbers in Excel

Excel Numbers
 

Is there any advantage to formatting as special over formatting as text?
--
Brevity is the soul of wit.


"Sean Timmons" wrote:

Or, format as Special, and type in as many zeros as you want characters.
(i.e. - need a ten digit number, enter 10 0's)

"Dave F" wrote:

Format the cells as text.

Dave
--
Brevity is the soul of wit.


"Excelinator" wrote:

How do you keep zeros in front of numbers in Excel

Excel Numbers
 

Specially formatted numbers remain numbers and can be directly used in
calculations. Text has to be first converted to a number before calculating.
--
Ted