Thread: Cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY GARY is offline
external usenet poster
 
Posts: 117
Default Cell format

A cell contains 1234.

I then format the cell by doing /FORMAT/CELLS/NUMBER/CUSTOM with "type"
= 00000000000 and I press OK. The cell's contents is displayed
00000001234.

However, the length of the cell is only 4 characters (not 11) and its
format has changed from "Custom" to "Special".

How do I keep the "Custom" formatting?