| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right formating with an ident
How can I format a number value to the right, but with an identation? I can
see that there is an ident only for left formating in the format cell. Merry Christmas Yakimoto |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Right formating with an ident
Format the cell with a custom format of (without quotes) "@ "
Just put as many spaces as you need. "Yakimoto" wrote in message ... How can I format a number value to the right, but with an identation? I can see that there is an ident only for left formating in the format cell. Merry Christmas Yakimoto |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Right formating with an ident
Since you said the cell would contain a number, you would probably use:
#,##0____ ;-#,##0___) as a custom number format. -- Regards, Tom Ogilvy "Yakimoto" wrote in message ... How can I format a number value to the right, but with an identation? I can see that there is an ident only for left formating in the format cell. Merry Christmas Yakimoto |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Right formating with an ident
Quite right Tom, I should have been paying attention :-)
"Tom Ogilvy" wrote in message ... Since you said the cell would contain a number, you would probably use: #,##0____ ;-#,##0___) as a custom number format. -- Regards, Tom Ogilvy "Yakimoto" wrote in message ... How can I format a number value to the right, but with an identation? I can see that there is an ident only for left formating in the format cell. Merry Christmas Yakimoto |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating help | Excel Discussion (Misc queries) | |||
| If, Then, Or formating | Excel Discussion (Misc queries) | |||
| formating | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Formating h:mm AM/PM | Excel Discussion (Misc queries) | |||
Linear Mode
