Hi
use

#,##0"-001"



"Gilbert" wrote:

Thanks Eduardo. But I was hoping not to have the decimal.

"Eduardo" wrote:

Hi,
custom format and enter

#,0.-001

"Gilbert" wrote:

I have to enter a nine digt number followed by -001. For example
123456789-001.
How can I format the cell so that I don't have to enter -001 since it's
constant?