decimal alignment of numbers with various decimals

Kristel · May 6th, 2002, 05:11 AM

--------------------------------------------------------------------------------
I need to "decimal align" a lot of numbers , some of them with decimals of varying length, others without decimals. When the numbers have no decimals, i don't want to see a decimal separator. If i use the ? i only see the decimals i need to see but i can 't get rid of the decimal sign for the whole numbers. Can anyone help me???
Thanks a lot!!!!

Brian · May 6th, 2002, 11:16 PM

I can't imagine why you would need that but...

I could not find a cell format that worked. You could try to simulate what you want by placing the whole numbers in one column, right justified, and place the decimal portion in the next column, left justified. The problem is that the spacing on each side of the decimal will probably not match. Therefore you could split it into three columns whole number, decimal ,and decimals, but that's ugly.

You could also convert the numbers to text, use a constant width font. You should be able to make a suitable equation from the available math and text functions.

Good luck,

Brian

crimlet · May 7th, 2002, 12:48 AM

You could use the text to columns with the delimiter set as "." if you then left align anything in the right hand columns (the decimal numbers) and right align the left hand column (Whole numbers) this will give you a printable version of what you are looking for

Kristel · May 24th, 2002, 04:10 AM

i don 't need this for a printout and the numbers should remain numbers so converting them to text won't do...
it really should look like this:
2
100
30,34
111,3345

i still hope someone will find a solution...

Kristel · May 24th, 2002, 04:13 AM

my example in the foregoing message didn't work...i see al the spaces are lost so my firgures aren't aligned as they should.

Aladin Akyurek · Jun 28th, 2002, 12:50 AM

Quote:

On 2002-05-06 04:11, Kristel wrote:
--------------------------------------------------------------------------------
I need to "decimal align" a lot of numbers , some of them with decimals of varying length, others without decimals. When the numbers have no decimals, i don't want to see a decimal separator. If i use the ? i only see the decimals i need to see but i can 't get rid of the decimal sign for the whole numbers. Can anyone help me???
Thanks a lot!!!!

Kristel,

Did you try

#,##0.??????_);(#,##0.??????);0.??????_);@

which is a custom format?

Aladin

inarbeth · Jun 28th, 2002, 01:47 AM

[/quote]

Kristel,

Did you try

#,##0.??????_);(#,##0.??????);0.??????_);@

which is a custom format?

Aladin

[/quote]

Aladin
I get a decimal after integers when using that format, e.g 2 becomes 2.

Aladin Akyurek · Jun 28th, 2002, 06:52 AM

Quote:

On 2002-06-28 00:47, inarbeth wrote:

Quote:

Kristel,

Did you try

#,##0.??????_);(#,##0.??????);0.??????_);@

which is a custom format?

Aladin

Aladin
I get a decimal after integers when using that format, e.g 2 becomes 2.

That's right. The following

#,##0.0?????_);(#,##0.??????);0.0?????_);@

would show 2 as 2.0

Anything better on offer would be nice.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 05:11 AM	#1
Kristel New Member Join Date: May 2002 Location: Belgium Posts: 4	-------------------------------------------------------------------------------- I need to "decimal align" a lot of numbers , some of them with decimals of varying length, others without decimals. When the numbers have no decimals, i don't want to see a decimal separator. If i use the ? i only see the decimals i need to see but i can 't get rid of the decimal sign for the whole numbers. Can anyone help me??? Thanks a lot!!!!

May 6th, 2002, 11:16 PM	#2
Brian Board Regular Join Date: Apr 2002 Posts: 113	I can't imagine why you would need that but... I could not find a cell format that worked. You could try to simulate what you want by placing the whole numbers in one column, right justified, and place the decimal portion in the next column, left justified. The problem is that the spacing on each side of the decimal will probably not match. Therefore you could split it into three columns whole number, decimal ,and decimals, but that's ugly. You could also convert the numbers to text, use a constant width font. You should be able to make a suitable equation from the available math and text functions. Good luck, Brian

May 7th, 2002, 12:48 AM	#3
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	You could use the text to columns with the delimiter set as "." if you then left align anything in the right hand columns (the decimal numbers) and right align the left hand column (Whole numbers) this will give you a printable version of what you are looking for

May 24th, 2002, 04:10 AM	#4
Kristel New Member Join Date: May 2002 Location: Belgium Posts: 4	i don 't need this for a printout and the numbers should remain numbers so converting them to text won't do... it really should look like this: 2 100 30,34 111,3345 i still hope someone will find a solution...

May 24th, 2002, 04:13 AM	#5
Kristel New Member Join Date: May 2002 Location: Belgium Posts: 4	my example in the foregoing message didn't work...i see al the spaces are lost so my firgures aren't aligned as they should.

Jun 28th, 2002, 01:47 AM	#7
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	[/quote] Kristel, Did you try #,##0.??????_);(#,##0.??????);0.??????_);@ which is a custom format? Aladin [/quote] Aladin I get a decimal after integers when using that format, e.g 2 becomes 2.