Sorry, I can't get what you want if it did't...

BTW, seem that the original format was set by others which referred to a
certain template (file) you may not have it.
--
CKKwok


"peyman" wrote:

Sorry, It didn't work.
I changed the Format Cells/Number to Custom with 6 zeros but still the
appearnce is like 012345 in the cell and 12345 in the fx Edit Bar.
Thanx anyway.

"CKK" wrote:

More simply as to set the number format as 6 digits (000000) display when you
needed 0 shown in prefix of any digits typed in less than 6 digits, such as
you type in 5 digits in a cell, like 12345 shown in fx field (edit bar) then
012345 displayed on the cell.

To set this, 1st, select the whole COLUMN/ROW (s) or the area (like A1:C20)
you want for this format, then click (from the menu or the right button of
the Mouse)FORMAT--CELL--CUSTOM, type in 0...(at the Style field) as many as
how you want a integrated digits display in a cell, for 6 digits shown as
above then type in six 0 as 000000 or for 8 digits then 00000000

hope it's helpfull!
--
CKKwok


"peyman" wrote:

Hi,
I've a column of "purchase order" numbers starting with zero like
025639,045698,083354,... .I wonder somehow the Format Cell/Number of the
cells in this column is set to "Special"; "Locale(Location): Chinese (PRC) ;
"Type" : some chinese words; and "sample" : 085815.
When you are on the cell ,the content on the toolbal (infront of fx )is
84325 , but what you see on the spreadsheet is 084325.
And also when I change the format cell to "text", the 0's at the beginning
of the contents are removed.I wanna know if there is any way to change the
format cell to "text" or something else and at the same time keep the 0's in
the cells?
I hope my explanation is clear!!
Thanks for ur help.
Peiman