View Single Post
  #7   Report Post  
Old July 8th 08, 05:22 PM posted to microsoft.public.excel.setup
Rory[_2_] Rory[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default That didn't come out

Hey, it's pretty easy to do.

In the custom format, just type:

"MCY ID "#;"MCY ID "#;"MCY ID 00000";"MCY ID "@

Numbers are taken care of by the first 3 parts, and alphanumeric entries are done by the last (whatever text is entered in the cell will be placed where the "@" is). This doesn't make sure that only 5 characters are entered, but it is simple and easy to create.