Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting - aligning decimal points
Does anyone know the best/most efficient way to customize the number formats
such that you can align the decimal point in a series of numbers in a column where some numbers use a currency sign and some do not while using a non-fixed-width font? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting - aligning decimal points
An underscore followed by a character creates a space the width of that
character. _$ or Some combinations of ??.?? will align decimal points. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Emily" wrote in message Does anyone know the best/most efficient way to customize the number formats such that you can align the decimal point in a series of numbers in a column where some numbers use a currency sign and some do not while using a non-fixed-width font? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting - aligning decimal points
Thanks, Jim, for your reply (and happy holidays!). I think that i am not
familiar enough with the combination of characters to do this right as I gave it a try and I wasn't successful. "Jim Cone" wrote: An underscore followed by a character creates a space the width of that character. _$ or Some combinations of ??.?? will align decimal points. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Emily" wrote in message Does anyone know the best/most efficient way to customize the number formats such that you can align the decimal point in a series of numbers in a column where some numbers use a currency sign and some do not while using a non-fixed-width font? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
conditonally formatting decimal places | Excel Discussion (Misc queries) | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
why 2003 excell does not accept dot as decimal points | Excel Discussion (Misc queries) |