Thread: Custom Cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_2_] Little Penny[_2_] is offline
external usenet poster
  
Posts: 23
Default Custom Cell format
Is it possible to create a custom cell format so that all entries are
force to look as follows?

JI-1234567

The (JI-) are constant followed by a combination of seven digits.

Can I do this in excel or is a macro needed?

Reply With QuoteReply With Quote