Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can not find align decimal points option
Format | Cells | Number and set for designed number of decimal places.
-- Rae Drysdale "nastech" wrote: saw in xl help file, but not re-searchable. trying to align decimal points. other problem exists with number/text formating, e.g.: 1.5B or 1.5M using some workarounds: - distribute formatting gets rid of seeing b/m - cond. formatting colors represents millions or billions - still have mis alignement: 104 21. 1.0 - Recommend MS allow use of Custom formatting "in-cell" for text / number strings. if can't already do |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can not find align decimal points option
hi, thanks. think I saw in help somewhere was specifically stated to align
decimal point, something of a centered on decimal point fashion. if shows here in text: 100.0 1.511 0.21 "Rae Drysdale" wrote: Format | Cells | Number and set for designed number of decimal places. -- Rae Drysdale "nastech" wrote: saw in xl help file, but not re-searchable. trying to align decimal points. other problem exists with number/text formating, e.g.: 1.5B or 1.5M using some workarounds: - distribute formatting gets rid of seeing b/m - cond. formatting colors represents millions or billions - still have mis alignement: 104 21. 1.0 - Recommend MS allow use of Custom formatting "in-cell" for text / number strings. if can't already do |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can not find align decimal points option
Format/Cells/Number:Accounting, set number of decimal places.
If you choose number of decimanl places = 5, then 100.5 will appear as 100.50000 This is the closest I've been able to find. If you don't want the $ mark, you can choose Symbol as none. A decimal tab in Word will do what you're talking about. It even works with alphabetoc characters. I wish there were something similar in Excel. "nastech" wrote: hi, thanks. think I saw in help somewhere was specifically stated to align decimal point, something of a centered on decimal point fashion. if shows here in text: 100.0 1.511 0.21 "Rae Drysdale" wrote: Format | Cells | Number and set for designed number of decimal places. -- Rae Drysdale "nastech" wrote: saw in xl help file, but not re-searchable. trying to align decimal points. other problem exists with number/text formating, e.g.: 1.5B or 1.5M using some workarounds: - distribute formatting gets rid of seeing b/m - cond. formatting colors represents millions or billions - still have mis alignement: 104 21. 1.0 - Recommend MS allow use of Custom formatting "in-cell" for text / number strings. if can't already do |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can not find align decimal points option
Actually, as Rae (almost) said Format/Cells/Number/Number gives the same
thing if you don't want the $ sign. I was thinking it did something else. "nastech" wrote: hi, thanks. think I saw in help somewhere was specifically stated to align decimal point, something of a centered on decimal point fashion. if shows here in text: 100.0 1.511 0.21 "Rae Drysdale" wrote: Format | Cells | Number and set for designed number of decimal places. -- Rae Drysdale "nastech" wrote: saw in xl help file, but not re-searchable. trying to align decimal points. other problem exists with number/text formating, e.g.: 1.5B or 1.5M using some workarounds: - distribute formatting gets rid of seeing b/m - cond. formatting colors represents millions or billions - still have mis alignement: 104 21. 1.0 - Recommend MS allow use of Custom formatting "in-cell" for text / number strings. if can't already do |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
need short cuts in the find option | Excel Discussion (Misc queries) | |||
Filter option | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |