Cell Format
 

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?

Cell Format
 

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?

Cell Format
 

General"-001"
--
David Biddulph

"Gilbert" wrote in message
...
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?

Cell Format
 

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?

Cell Format
 

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?

Cell Format
 

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

"Gilbert" wrote in message
...
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?

Cell Format
 

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

"Eduardo" wrote:

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?

Cell Format
 

Thank you David.

"David Biddulph" wrote:

General"-001"
--
David Biddulph

"Gilbert" wrote in message
...
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?


.