| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
& help with date format
Hello and thanks for the help.
I am bringing together two cells one with the date and then a dash, the next cell has my note. I cannot seem to figure out how to keep the date format. Any help? Friday, February 10, 2006 My note goes here =c2&" - "&C3 38758 - My note goes here |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& help with date format
Use the text function to tell Excel how to format the number in C2 (dates are
really just numbers formatted in a certain way). =text(c2,"dddd, mmmm dd, yyyy") & " - " & c3 --Bruce "JR" wrote: Hello and thanks for the help. I am bringing together two cells one with the date and then a dash, the next cell has my note. I cannot seem to figure out how to keep the date format. Any help? Friday, February 10, 2006 My note goes here =c2&" - "&C3 38758 - My note goes here |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& help with date format
This is great - thanks
Can you also tell me how I would go about making the date bold? Thanks again "bpeltzer" wrote: Use the text function to tell Excel how to format the number in C2 (dates are really just numbers formatted in a certain way). =text(c2,"dddd, mmmm dd, yyyy") & " - " & c3 --Bruce "JR" wrote: Hello and thanks for the help. I am bringing together two cells one with the date and then a dash, the next cell has my note. I cannot seem to figure out how to keep the date format. Any help? Friday, February 10, 2006 My note goes here =c2&" - "&C3 38758 - My note goes here |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
& help with date format
You can't do that through a formula, but you could through format.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "JR" wrote in message ... This is great - thanks Can you also tell me how I would go about making the date bold? Thanks again "bpeltzer" wrote: Use the text function to tell Excel how to format the number in C2 (dates are really just numbers formatted in a certain way). =text(c2,"dddd, mmmm dd, yyyy") & " - " & c3 --Bruce "JR" wrote: Hello and thanks for the help. I am bringing together two cells one with the date and then a dash, the next cell has my note. I cannot seem to figure out how to keep the date format. Any help? Friday, February 10, 2006 My note goes here =c2&" - "&C3 38758 - My note goes here |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Linear Mode
