| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| Number Formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
