| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Outline different number formats
I'm trying to outline an column with different number formats, so that the (in some cases virtual) comma is always on the same place. Example: _300 ___1.25 __20.2 1000 (the underscores replresent blanks, but without them, they are all aligned left in the post :) ) Can anyone help me? -- glasbergenm ------------------------------------------------------------------------ glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001 View this thread: http://www.excelforum.com/showthread...hreadid=550251 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Outline different number formats
Why not use a number format with a fixed number of decimals ?
300,00 1,25 20,20 1000,00 HTH "glasbergenm" wrote: I'm trying to outline an column with different number formats, so that the (in some cases virtual) comma is always on the same place. Example: _300 ___1.25 __20.2 1000 (the underscores replresent blanks, but without them, they are all aligned left in the post :) ) Can anyone help me? -- glasbergenm ------------------------------------------------------------------------ glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001 View this thread: http://www.excelforum.com/showthread...hreadid=550251 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Outline different number formats
Because in some cases, a decimal number is nonsence. For example, a number of people looks a bit odd when showing them as 30.00. -- glasbergenm ------------------------------------------------------------------------ glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001 View this thread: http://www.excelforum.com/showthread...hreadid=550251 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Outline different number formats
Can you show the decimal point all the time?
If yes, try: #,##0.???? or 0.???? Use as many ???? as your worst decimal has. glasbergenm wrote: I'm trying to outline an column with different number formats, so that the (in some cases virtual) comma is always on the same place. Example: _300 ___1.25 __20.2 1000 (the underscores replresent blanks, but without them, they are all aligned left in the post :) ) Can anyone help me? -- glasbergenm ------------------------------------------------------------------------ glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001 View this thread: http://www.excelforum.com/showthread...hreadid=550251 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of userdefined formats | Setting up and Configuration of Excel | |||
| Sumproduct with different number formats | Excel Discussion (Misc queries) | |||
| number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
| Conditional Number Formats | Excel Discussion (Misc queries) | |||
| number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
Linear Mode
