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