LifeTips Home
Software Tips
March 12, 2010
March 5, 2010
February 26, 2010
February 19, 2010
February 5, 2010
January 29, 2010
January 22, 2010
January 15, 2010
January 8, 2010
January 1, 2010
December 25, 2009
December 18, 2009
December 11, 2009
December 4, 2009
November 27, 2009
November 20, 2009
November 13, 2009
November 6, 2009
October 30, 2009
October 23, 2009
October 16, 2009
October 9, 2009
October 2, 2009
September 25, 2009
September 18, 2009
September 11, 2009
September 4, 2009
August 28, 2009
August 21, 2009
August 14, 2009
August 7, 2009
July 31, 2009
July 24, 2009
July 17, 2009
July 10, 2009
July 3, 2009
June 26, 2009
June 19, 2009
June 12, 2009
June 5, 2009
May 29, 2009
May 22, 2009
May 15, 2009
May 8, 2009
May 1, 2009
April 24, 2009
April 17, 2009
April 10, 2009
April 3, 2009
March 27, 2009
March 20, 2009
March 13, 2009
March 6, 2009
February 20, 2009
February 13, 2009
February 6, 2009
January 30, 2009
January 23, 2009
January 16, 2009
January 9, 2009
January 2, 2009
December 26, 2008
December 19, 2008
December 12, 2008
December 5, 2008
November 28, 2008
November 21, 2008
November 14, 2008
November 7, 2008
October 31, 2008
October 24, 2008
October 17, 2008
October 10, 2008
October 3, 2008
September 26, 2008
September 19, 2008
September 12, 2008
September 5, 2008
August 29, 2008
August 22, 2008
August 15, 2008
August 8, 2008
August 1, 2008
July 25, 2008
July 18, 2008
July 11, 2008
July 4, 2008
June 27, 2008
June 20, 2008
June 13, 2008
June 6, 2008
May 30, 2008
May 23, 2008
May 16, 2008
May 9, 2008
May 2, 2008
April 25, 2008
April 18, 2008
April 11, 2008
April 4, 2008
March 28, 2008
March 21, 2008
March 14, 2008
March 7, 2008
February 29, 2008
February 22, 2008
February 15, 2008
February 8, 2008
February 1, 2008
January 25, 2008
January 18, 2008
January 11, 2008
January 4, 2008
December 28, 2007
December 21, 2007
December 14, 2007
December 7, 2007
November 30, 2007
November 23, 2007
November 16, 2007
November 9, 2007
November 2, 2007
October 26, 2007
October 19, 2007
October 12, 2007
October 5, 2007
September 28, 2007
September 21, 2007
September 14, 2007
September 7, 2007
August 31, 2007
August 24, 2007
August 17, 2007
August 10, 2007
August 3, 2007
July 27, 2007
July 13, 2007
July 6, 2007
June 29, 2007
June 22, 2007
June 15, 2007
June 8, 2007
June 1, 2007
May 25, 2007
May 18, 2007
May 11, 2007
May 4, 2007
April 27, 2007
April 20, 2007
April 13, 2007
April 6, 2007
March 30, 2007
March 23, 2007
March 16, 2007
March 9, 2007
March 2, 2007
February 23, 2007
February 16, 2007
February 9, 2007
February 2, 2007
January 26, 2007
January 19, 2007
January 12, 2007
January 5, 2007
December 29, 2006
December 22, 2006
December 15, 2006
December 8, 2006
December 1, 2006
November 24, 2006
November 17, 2006
October 27, 2006
October 20, 2006
October 13, 2006
October 6, 2006
September 29, 2006
September 22, 2006
September 15, 2006
September 8, 2006
September 1, 2006
August 25, 2006
August 18, 2006
August 4, 2006
July 21, 2006
July 14, 2006
July 7, 2006
June 30, 2006
June 23, 2006
June 16, 2006
June 9, 2006
June 2, 2006
May 26, 2006
May 19, 2006
May 12, 2006
May 5, 2006
April 28, 2006
April 21, 2006
April 14, 2006
April 7, 2006
March 31, 2006
March 17, 2006
March 10, 2006
March 3, 2006
February 24, 2006
February 17, 2006
February 10, 2006
February 3, 2006
January 27, 2006
July 4, 2003
June 27, 2003
June 6, 2003
May 30, 2003
March 7, 2003
February 28, 2003
February 21, 2003
February 14, 2003
February 7, 2003
January 31, 2003
January 24, 2003
January 17, 2003
January 10, 2003
January 3, 2003
December 27, 2002
December 20, 2002
December 13, 2002
December 6, 2002
November 29, 2002
November 22, 2002
November 15, 2002
November 8, 2002
November 1, 2002
October 25, 2002
October 18, 2002
October 11, 2002
October 4, 2002
September 27, 2002
September 20, 2002
September 13, 2002
August 30, 2002
August 16, 2002
August 9, 2002
August 2, 2002
July 26, 2002
July 19, 2002
July 12, 2002
July 5, 2002
June 28, 2002
June 21, 2002
June 14, 2002
June 7, 2002
May 31, 2002
May 24, 2002
May 17, 2002
May 10, 2002
May 3, 2002
April 26, 2002
April 19, 2002
April 12, 2002
April 5, 2002
March 29, 2002
March 22, 2002
March 15, 2002
March 8, 2002
March 1, 2002
February 22, 2002
February 15, 2002
February 8, 2002
February 1, 2002
January 25, 2002
January 18, 2002
January 11, 2002
January 4, 2002
December 7, 2001
November 30, 2001
November 23, 2001
November 16, 2001
November 9, 2001
November 2, 2001
October 26, 2001
October 19, 2001
October 12, 2001
October 5, 2001
September 21, 2001
September 14, 2001
September 7, 2001
August 31, 2001
August 24, 2001
August 17, 2001
August 10, 2001
August 3, 2001
July 20, 2001
July 13, 2001
July 6, 2001
June 29, 2001
June 22, 2001
June 15, 2001
June 8, 2001
May 25, 2001
May 18, 2001
May 11, 2001
May 4, 2001
April 27, 2001
April 20, 2001
April 6, 2001
March 16, 2001
March 9, 2001
March 2, 2001
February 23, 2001
February 16, 2001
February 9, 2001
February 2, 2001
January 26, 2001
January 19, 2001
January 12, 2001
December 22, 2000
December 15, 2000
December 8, 2000
November 24, 2000
November 17, 2000
November 10, 2000
November 3, 2000
October 27, 2000
October 6, 2000
September 29, 2000
September 22, 2000
September 15, 2000
September 1, 2000

Get Fresh Tips Every Week!
Don't Miss Any Software Tips. Subscribe to the Software Tip Newsletter.
View Archive

Bookmark      RSS
 

Business Solutions
Our tips are powerful.
Our writers are experts.
Our results are guaranteed.
 

Listen to our Radio Show
Hot topics for both consumers
and webmarketers
on WebmasterRadio.FM

Every Wednesday, 4PM Eastern.
 

June 6, 2008, Newsletter Issue #259: Excel´s DOLLAR function - what does it do?


1

Tip of the Week

Excel´s DOLLAR function converts any number to text using the currency format.

If cell A1 contains 123,
=DOLLAR(A1)
will return £123.00 (as text, not as a number).

The default number of decimal places is 2, but the number of decimal places can be modified by adding a comma and a number after the cell reference.

In the above example,
=DOLLAR(A1,5)
Would return £123.00000



2

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.



Learn more about our Exclusive Program we offer our clients.


 
Founded in 2000, LifeTips.com, Inc offers custom publishing programs to writers
and businesses that want to share knowledge and advice to millions of readers on
the web, and in printed and digital books.
Privacy Guaranteed.
Satisfaction Required.