View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Sure. Just type it with an apostrophe in front, or format the cells. For a
good example, choose Format-Cells, Number tab. Then choose
Special--Zipcode. It shows "00000". So if your numbers are 10-digit account
numbers, put "0000000000"
Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bennos" wrote in message
...
Is it possible to display a zero at the front of a series of numbers in a
cell?

Eg. "0123" is displayed as "123". How to display as original "0123"?

I've got the 'zero value' checked in Tools - Options - View. That is only
for a zero value in a cell without any other numbers in that cell.

Thanks in advance!!