User Login

Help Community Login:

Align Decimals In Numbers With Variable Decimal Places In MS Excel

6 replies [Last post]
missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3109
Drops: 3812
Mood: Weird

If you have a spreadsheet that has variable decimal places and need to align them in a column on the decimal point regardless of the number of digits before and after the decimal, here's how:

Decimals not aligned:

Select your rows that you want to be aligned, right click and choose "Format Cells", go to the "Number" tab and choose "Custom", in the "Type" put in a ? to the right of the decimal point for the maximum number of decimal places you'll need. In my example it's three (.123, .888), hit OK, all your decimals will be aligned Smile

Decimals aligned

This should work for both Excel 2003 & 2007
I Averaged: 3.5 | 6 votes


Read More ...





Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Autumn's picture
Autumn
Premium Member (Gold)I'm a Code Monkey!I use Google ChromeWindows UserI donated more than $20+ to GeekDrop!I donated to GeekDrop simply because I love it!I spend all day Photobucketing!I took a bite of the AppleIs a FIERCE Competetor! 2nd place contest winner!The Dr. left the stem off the apple!Someone thinks you're udderly delightful!
Joined: 09/12/2009
Posts: 254
Drops: 339
Mood: Content
Groups: Geekdrop Cafe
Re: Align Decimals In Numbers With Variable Decimal Places ...

great stuff missb, i have spent so much time messing around with this and could never figure it out

Smartmom's picture
From:
Wellington Florida
Smartmom
Banned Member (Way To Go!)
Relationship Status:
Married
Joined: 01/15/2009
Posts: 6392
Drops: -21
Mood: Giggly
Re: Align Decimals In Numbers With Variable Decimal Places ...

Oh very nice, I hate spending hours trying to figure things like this out. Love the tips, keep them coming!!!

Scott's picture
Scott
Re: Align Decimals In Numbers With Variable Decimal Places ...

Thanks, useful tip.

Is there any way to do this without losing the leading 0 of, say, 0.123?

mikc's picture
mikc
Re: Align Decimals In Numbers With Variable Decimal Places ...

This trick does not function in windows office 2010

a's picture
a
Re: Align Decimals In Numbers With Variable Decimal Places ...

0.0?? Will give you a leading and a trailing number (so will give you 0.75, but also 37.0).

wtleitch's picture
wtleitch
Re: Align Decimals In Numbers With Variable Decimal Places ...

I format my cells with: $??#,##0.00 or some combination of #s and ?s to get the decimals to align.

Who's New

kik's picture
TANVIR's picture
HeaDHunteR's picture
cameron101914's picture
yogi6796's picture
greeg's picture
abele2017's picture
val5val's picture
olamipoolatokunbo's picture
ariel402's picture
kevimart's picture
vin's picture
WendyLong's picture
Zarkman's picture
Sarwarips's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2017
TOS | Privacy Policy