Formatting number

C

Connie Martin

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
 
T

T. Valko

You can use this custom number format:

general;general;-;general

Then format the cell to center.
 
C

Connie Martin

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
R

Rick Rothstein \(MVP - VB\)

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

Rick
 
C

Connie Martin

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


Rick Rothstein (MVP - VB) said:
Oh, those "decimal numbers"<g>... yes, I think you are correct about that
interpretation (the words "combine all that" are what threw me).

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top