| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formatting question
I need c1 to equal A1.B1. I know how to get C1=A1&B1 but I need a period
separating them. Then in D1 I need it to equal . Help would be appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formatting question
C1: =A1&","&B1
D1: " HTH -- AP "Aaron Daniels" a écrit dans le message de ... I need c1 to equal A1.B1. I know how to get C1=A1&B1 but I need a period separating them. Then in D1 I need it to equal . Help would be appreciated |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formatting question
Aaron,
You could try this: In cell C1 type: =A1&"."&B1 In cell D1 type: " As far as enabling the hyperlink so that all you do is click. I don't know, but you could do it via VBA. You can create a forumula that will 'mailto' but that will only open a blank email. Hope this helps. "Aaron Daniels" wrote: I need c1 to equal A1.B1. I know how to get C1=A1&B1 but I need a period separating them. Then in D1 I need it to equal . Help would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
| Question about Excel | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
| Pivot / general chart formatting question | Charts and Charting in Excel | |||
Linear Mode
