| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indenting numbers from the right side of a cell
Hi,
I have Excel 2003. I can indent numbers in a cell from the right by clicking Format Cells Number Tab Custom and then typing in the Type box _). I have just found out that typing 0_0 in the tye box will also indent numbers from the right. Can someone explain to me the "logic" behind this? Thank you very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indenting numbers from the right side of a cell
hi, jfg !
I can indent numbers in a cell from the right by clicking Format Cells Number Tab Custom and then typing in the Type box _). I have just found out that typing 0_0 in the tye box will also indent numbers from the right. Can someone explain to me the "logic" behind this? AFAIK, in custom number formats... - the underscore end-character *uses* the lenght of the following character for right-indentation i.e.: 0_| or: 0_@ or: 0_? hth, hector. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indenting numbers from the right side of a cell
Thank you very much, Hector. By the way, what is "AFAIK"?
"Héctor Miguel" wrote: hi, jfg ! I can indent numbers in a cell from the right by clicking Format Cells Number Tab Custom and then typing in the Type box _). I have just found out that typing 0_0 in the tye box will also indent numbers from the right. Can someone explain to me the "logic" behind this? AFAIK, in custom number formats... - the underscore end-character *uses* the lenght of the following character for right-indentation i.e.: 0_| or: 0_@ or: 0_? hth, hector. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indenting numbers from the right side of a cell
hi, jfg !
Thank you very much, Hector. By the way, what is "AFAIK"? it's an usenet acronym, meaning: As Far As I Know another example: BTW = By The Way see: http://silmaril.ie/cgi-bin/uncgi/acronyms hth, hector. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indenting numbers from the right side of a cell
Thanks, Hector. That is a good site. I found AFAIK immediately.
The very best to you... jfg "Héctor Miguel" wrote: hi, jfg ! Thank you very much, Hector. By the way, what is "AFAIK"? it's an usenet acronym, meaning: As Far As I Know another example: BTW = By The Way see: http://silmaril.ie/cgi-bin/uncgi/acronyms hth, hector. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I extract the numbers from the right side of the cell | Excel Discussion (Misc queries) | |||
| Round up numbers to either a half or a whole depending on which side of 0.5 it is | Excel Discussion (Misc queries) | |||
| don't want numbers down the side | Excel Discussion (Misc queries) | |||
| How do I display positive numbers on either side of the x-axis? | Charts and Charting in Excel | |||
| Tabbing/Indenting within a cell | New Users to Excel | |||
Linear Mode
