Using the sum function to display number as well as words in a single cell

		Microsoft Office Forums > Microsoft Excel > Excel
Using the sum function to display number as well as words in a single cell

10-21-2013, 08:09 AM

officeboy09 officeboy09 is offline

Windows XP Using the sum function to display number as well as words in a single cell

Office 2003

Advanced Beginner

Join Date: Oct 2013

Location: Australia

Posts: 40

Quote:

Originally Posted by Pecoflyer

Try ="Total: "&sum(h1:h9)

Thanks Peco, it works!!

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
How can I break a single group of words into three sets?	Learner7	Excel	1	03-22-2011 02:35 PM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Pasting multiple photos - one photo per cell in a single oepration	mccruise	Word	0	04-07-2010 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 AM.