| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is being changed to a number (problem)
I have 4 columns of data which I want to add together to make one column of
data. 3 of the columns are text and one is a date. The formula I have used is.. ="text here "&C21&" more words here "&D21&","&" client ID "&E21&" went to "&F21 so it reads text as a sentence. The problem is that "&F21 is a date, and it displays it as a number, not a date. The formatting doesnt get carried across. The formatting of both columns are formated as dates. Can anyone help to make it display as a real date in the forumla column? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date is being changed to a number (problem)
&TEXT(F21,"dd mmm yyyy") or another formatting string
-- Kind regards, Niek Otten "Luke" wrote in message ... I have 4 columns of data which I want to add together to make one column of data. 3 of the columns are text and one is a date. The formula I have used is.. ="text here "&C21&" more words here "&D21&","&" client ID "&E21&" went to "&F21 so it reads text as a sentence. The problem is that "&F21 is a date, and it displays it as a number, not a date. The formatting doesnt get carried across. The formatting of both columns are formated as dates. Can anyone help to make it display as a real date in the forumla column? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date is being changed to a number (problem)
superb Niek ! thanks a lot mate it worked
"Niek Otten" wrote: &TEXT(F21,"dd mmm yyyy") or another formatting string -- Kind regards, Niek Otten "Luke" wrote in message ... I have 4 columns of data which I want to add together to make one column of data. 3 of the columns are text and one is a date. The formula I have used is.. ="text here "&C21&" more words here "&D21&","&" client ID "&E21&" went to "&F21 so it reads text as a sentence. The problem is that "&F21 is a date, and it displays it as a number, not a date. The formatting doesnt get carried across. The formatting of both columns are formated as dates. Can anyone help to make it display as a real date in the forumla column? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Date & Time problem | Excel Worksheet Functions | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Linear Mode
