thank you so much!!!!!
--
Cindy B


"Gord Dibben" wrote:

FormatCellsNumberCustom 0" Years"


Gord Dibben MS Excel MVP

On Sun, 4 May 2008 18:53:00 -0700, Cindy B wrote:

How do I insert text in a field - but just have the user enter the number?
example..
I want the field to be 5 years, but I only the the user to enter the number 5.
I've seen this done in Excel - but can not figure out how to do it.

thanks for any help you can send my way!