Cell Format

[Gilbert]

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?

 

[Eduardo]

Hi,
custom format and enter

#,0.-001

 

[David Biddulph]

General"-001"

 

[Gilbert]

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

 

[Eduardo]

Hi
use

#,##0"-001"

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

 

[David Biddulph]

0"-001",
or General"-001" as I suggested earlier.

 

[Gilbert]

Thanks Eduardo. That's exactly what I was looking for.

 

[Gilbert]

Thank you David.

General"-001"
--
David Biddulph




.