Thread: Decimal tabs?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default Decimal tabs?

How do I use the decimal tab on my computer in excel 2007??
What's a decimal tab?


In MS-Word, a decimal tab lines up the decimal points in a column of
numbers, even if some have more decimal places than others; for example:
123.8
3.678
22.

One way to simulate this is to use the TEXT function with the format_text
parameter depending on how many decimal places the number has. This works
with fixed-width fonts (like Courier) when the result is right-justified in
the cell.

The following works for up to four decimal places. For more places, it
should be clear how to lengthen the format_text (the second parameter of
the TEXT function).

=TEXT(A1,
IF(MOD(1000*A1,1)=0,
IF(MOD(100*A1,1)=0,
IF(MOD(10*A1,1)=0,
IF(MOD(A1,1)=0,
"0. ","0.0 "),"0.00 "),"0.000 "),"0.0000"))