Thank you! It works perferct!

"Niek Otten" wrote:

FormatCellsNumberCustom

In the Type box, add "units" (including the quotes) to the end of the
current format string (probably General)

--
Kind regards,

Niek Otten

"hmz" wrote in message
...
I am trying to include a text with my input number. For example: I want to
input in cell A1 only the number "230." But, I want the cell to return
"230
units." What steps do I have to do to make that work? Thanks, hmz