Posted to microsoft.public.excel.programming

daddylonglegs[_31_] daddylonglegs[_31_] is offline

external usenet poster

Posts: 1

concatenate formulas

Try using the TEXT function within your concatenation, e.g.

=TEXT(A1,"0.0%") or

=TEXT(A1,"0.0")

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=531652

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
USE CONCATENATE function to connect 2 formulas	Jordan	Excel Worksheet Functions	4	September 30th 08 11:18 PM
how insert the return key in formulas for concatenate of text?	~0-0~	Excel Discussion (Misc queries)	2	March 18th 08 06:13 PM
Combining two formulas using concatenate	Confused Kate	Excel Worksheet Functions	3	September 21st 06 04:13 AM
concatenate formulas	[email protected]	Excel Programming	2	April 3rd 06 03:36 PM
Using Concatenate to create formulas?	Thor	Excel Discussion (Misc queries)	3	October 2nd 05 01:31 PM

All times are GMT +1. The time now is 11:08 AM.

About Us

"It's about Microsoft Excel"