 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007format decimal length
Hi there - I have a chart title linking to a cell that says: ="$5,000 invested annually @ " &average(U2:U40) Is there a way to limit the decimal length to only two places here? I've explored formatting and it's stuck at displaying 14 decimals. Thanks - Brian > I have a chart title linking to a cell that says: > ="$5,000 invested annually @ " &average(U2:U40) > Is there a way to limit the decimal length to only two places here? > ="$5,000 invested annually @ " & text(average(U2:U40), "0.00") Thank you, sir > > I have a chart title linking to a cell that says: > > ="$5,000 invested annually @ " &average(U2:U40) > > Is there a way to limit the decimal length to only two places here? > > ="$5,000 invested annually @ " & text(average(U2:U40), "0.00")- Hide quoted text - > > - Show quoted text -
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.