Thanx David, I knew it but the column's format is somehow changed!!

"David Biddulph" wrote:

If you want the "number" to be treated as text (and thus keep its leading
zeroes), you must format the cell as text *before* you enter the "number",
or prefix the "number" with an apostrophe.
--
David Biddulph

"peyman" wrote in message
...
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
)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