#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default add a number to text

Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of days
10))

Cheers


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default add a number to text

Does

Val(refbox1) + Val(refbox2)

get you where you want

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MillyD" wrote in message
...
Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of
days 10))

Cheers



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default add a number to text

assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1

MillyD wrote:

Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of days
10))

Cheers



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default add a number to text

Cheers........


"Bob I" wrote in message
...
assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1

MillyD wrote:

Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of
days 10))

Cheers




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default add a number to text

You're welcome, have a great day!

MillyD wrote:

Cheers........


"Bob I" wrote in message
...

assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1

MillyD wrote:


Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of
days 10))

Cheers







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula to change scientific number to regular number or text Compare Values Excel Discussion (Misc queries) 2 August 23rd 07 06:10 PM
Counting a mixed text/number column based on text in another colum Sierra Vista Steve Excel Discussion (Misc queries) 3 December 17th 06 05:30 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number Excel Worksheet Functions 2 June 23rd 05 01:02 AM
not able to convert text, or graphic number to regular number in e knutsenk Excel Worksheet Functions 1 April 2nd 05 08:41 AM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"