Formatting number
 

How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just like
the accounting format, but in Excel 2000 it doesn't let you center the number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer is
nothing. I want a dash, but want it centered. Thank you. Connie

Formatting number
 

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just
like
the accounting format, but in Excel 2000 it doesn't let you center the
number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer
is
nothing. I want a dash, but want it centered. Thank you. Connie

Formatting number
 

We meet again! Hi! Yes, that works, except have I have 8 decimal numbers
now. I only want one decimal. Is there a way to combine all that? Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just
like
the accounting format, but in Excel 2000 it doesn't let you center the
number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer
is
nothing. I want a dash, but want it centered. Thank you. Connie

Formatting number
 

Eight decimal numbers? You only want one? Are you talking about merging
cells? Select the 8 cells, go to the Format/Cells dialog box, format that
cell the way Biff told you on the Number tab, then set the Center/Center
condition (if it is not already set) and check the Merger Cells box on the
Alignment tab. If you meant something else, you will need to describe it in
more detail.

Rick


"Connie Martin" wrote in message
...
We meet again! Hi! Yes, that works, except have I have 8 decimal numbers
now. I only want one decimal. Is there a way to combine all that?
Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just
like
the accounting format, but in Excel 2000 it doesn't let you center the
number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the
answer
is
nothing. I want a dash, but want it centered. Thank you. Connie

Formatting number
 

Another guess...
0.0;-0.0;-;General
or
#,##0.0;-#,##0.0;-;General


Connie Martin wrote:

We meet again! Hi! Yes, that works, except have I have 8 decimal numbers
now. I only want one decimal. Is there a way to combine all that? Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just
like
the accounting format, but in Excel 2000 it doesn't let you center the
number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer
is
nothing. I want a dash, but want it centered. Thank you. Connie




--

Dave Peterson

Formatting number
 

Oh, those "decimal numbers"<g... yes, I think you are correct about that
interpretation (the words "combine all that" are what threw me).

Rick


"Dave Peterson" wrote in message
...
Another guess...
0.0;-0.0;-;General
or
#,##0.0;-#,##0.0;-;General


Connie Martin wrote:

We meet again! Hi! Yes, that works, except have I have 8 decimal
numbers
now. I only want one decimal. Is there a way to combine all that?
Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in
message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it
just
like
the accounting format, but in Excel 2000 it doesn't let you center
the
number
in the cell when using the accounting format. So, if I use "Custom"
in
Category, then what is the format code. I don't like zero when the
answer
is
nothing. I want a dash, but want it centered. Thank you. Connie




--

Dave Peterson

Formatting number
 

Thank you. I tried the first one and that worked. Thanks again! Connie

"Dave Peterson" wrote:

Another guess...
0.0;-0.0;-;General
or
#,##0.0;-#,##0.0;-;General


Connie Martin wrote:

We meet again! Hi! Yes, that works, except have I have 8 decimal numbers
now. I only want one decimal. Is there a way to combine all that? Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it just
like
the accounting format, but in Excel 2000 it doesn't let you center the
number
in the cell when using the accounting format. So, if I use "Custom" in
Category, then what is the format code. I don't like zero when the answer
is
nothing. I want a dash, but want it centered. Thank you. Connie




--

Dave Peterson

Formatting number
 

That's okay. It's hard to talk MVP language!! :) Appreciate all your help,
you guys! Connie


"Rick Rothstein (MVP - VB)" wrote:

Oh, those "decimal numbers"<g... yes, I think you are correct about that
interpretation (the words "combine all that" are what threw me).

Rick


"Dave Peterson" wrote in message
...
Another guess...
0.0;-0.0;-;General
or
#,##0.0;-#,##0.0;-;General


Connie Martin wrote:

We meet again! Hi! Yes, that works, except have I have 8 decimal
numbers
now. I only want one decimal. Is there a way to combine all that?
Connie

"T. Valko" wrote:

You can use this custom number format:

general;general;-;general

Then format the cell to center.

--
Biff
Microsoft Excel MVP


"Connie Martin" wrote in
message
...
How do I custom format the number so that a zero is a dash (like in
accounting format) but so that I can centre the number. I want it
just
like
the accounting format, but in Excel 2000 it doesn't let you center
the
number
in the cell when using the accounting format. So, if I use "Custom"
in
Category, then what is the format code. I don't like zero when the
answer
is
nothing. I want a dash, but want it centered. Thank you. Connie




--

Dave Peterson