View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default REMOVE ZERO FILL

Sounds like you have a special format applied to the cells. Select the cells
then
Edit | Clear | Formats
and see how they look.

"ichihina" wrote:

how can I remove zero fills?

000089 -- 89
0076---76
00HWY---- HWY