On Wed, 14 Feb 2007 07:38:35 -0800, Scott at Scott <Scott at
wrote:

Please Help, I've done every thing the online help provided. Like below in
the Custom block

\A 000 \A\A 0000
E 000 "EE" 0000
"E" 000 "EE" 0000

I need it to auto format to look like this E 605 EQ 1212

Thank You for your time.

Format/Cells/Number/Custom Type: "E "000 "EQ "0000

Then, in the cell, enter: 6051212

It will then display: E 605 EQ 1212





--ron