Smileys

Smiley	Acronyms
	:angel: O:)
	:angry: X(
	:blush: :\
	:brokenheart: =((
	:callme: :C
	:applause:
	:clown: :O)
	:confused: :/
	:cool: B)
	:cowboy:
	:crying: :'(
	:daydream:
	:devil: :evil:
	:doh:
	:drool:
	:suspect:
	:batlashes: :flirt:
	:frustrated:
	:grin: :D
	:love: :X
	:hug: :hugs:
	:hypnotize:
	:kiss: :*
	:lol: lol :))
	:liar:
	:loser:
	:nailbite:
	:nerd: :B
	:neutral: :\|
	:nottalking:
	:party:
	:phbbt: :raspberry:
	:onphone:
	:rofl: lmfao lmao =))
	:rolleyes: 8\|
	:sad: :(
	:shh: :$
	:sick: :&
	:sigh:
	:silly: 8}
	:sleepy:
	:smile: :) =)
	:smug:
	:surprise: :O
	:think: :hmm: hmm
	:timeout:
	:tongue: :P :p ;p ;P
	:ttthand:
	:waiting:
	:wave:
	:whew: :phew:
	:wink: ;)
	:worried: :S
	:yawn:
	:heart: <3
	:puppydogeyes:
	:idontknow:
	:moneyeyes:
	:beg: :praying:
	:cranky:
	:alien:
	:bug:
	:skull:
	:coffee:
	:pumpkin:
	:flag:
	:goodluck:
	:rose:
	:chicken:
	:monkey:
	:cow:
	:pig:
	:notlistening:
	:whistling:
	:beatup:
	:peace:
	:shameonyou:
	:dancing:
	:bringiton:
	:heehee:
	:chatterbox:
	:notworthy:
	:ohgoon:
	:star:
	:yinyang:
	:bee:
	:transformer:
	:hideseyes:
	:hurryup:
	:rockon:
	:thumbsdown:
	:thumbsup:
	:wasntme:
	:pirate:
	:gmconfused:
	:gmshocked:
	:gmrockout:
	:gmnosesmile:
	:gmnosegrin:
	:gmmonkey:
	:gmheart:
	:gmgrin:
	:gmsad:
	:gmequalsmile:
	:gmequalgrin:
	:gmcrying:
	:gmcool:
	:gmangry:
	:idea:
	:gmneutral:
	:gmtongue:
	:gmwink:
	:gmbignosewink:
	:gmnosewink:
	:jester:
	:wtf:
	:confused2:
	:snap:
	:pullhair:

3 replies [Last post]

Sat, 04/17/2010 - 12:22pm (2 years 5 weeks ago)

missb

is a dbag

Relationship Status:
Single & Not Looking

Joined: 01/16/2009

Posts: 3112

Drops: 3812

Mood: Weird

Groups: Advice Corner, AWESOME!, Book Worms, Broadway!, Game Group, Geekdrop Cafe, GeekDrop Pub, Jokes, Let's go to the Movies, MOM's Group, Sports Den, The Cooks Corner, U.S. Military, Words of the soul

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

Reply

Smileys

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <strike> <caption> <thead> <th> <param> <style> <BGSOUND> <color> <center> <font-size> <script>
You may quote other posts using [quote] tags.
Filtered words will be replaced with the filtered version of the word.
Textual smileys will be replaced with graphical ones.
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <csharp>, <css>, <html4strict>, <javascript>, <php>, <vb>, <vbnet>, <xml>. Beside the tag style "<foo>" it is also possible to use "[foo]".
Lines and paragraphs break automatically.
You can use BBCode tags in the text.

More information about formatting options

NOT LOGGED IN

NOTE: You are commenting as an anonymous guest. You will NOT immediately see your comment, but it's there. Please do not try to re-send the same comment. If you'd like to see it immediately, please login or create an account (no worries, it's free).

Reply

Popular Tags

Navigation

Member Buzz

Stalk Us!