It's not a number, so format isn't going to change it. You're going to have
to use
1) an additional cell and a formula, or
2) VBA code

route 1) assuming the values always look like your example, and assuming the
entry is in A1

=left(A1,1)&" "&mid(A1,2,3)&" "&mid(A1,5,2)&" "&right(A1,4)

let us know if you want to tackle the VBA side

"Scott at Scott" 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.