| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format date & number within a cell containing text
I'm trying to create cells in a worksheet which are text with calculated
dates & numbers imported from other cells in the workbook. My problem is that the date reverts to the numeric form & the numbers have many decimal places. I would like to retain the mm/dd/yyyy date format & display only whole numbers. The formula I am using to import the information is: ="text to appear with date" & Q5 or =L5& " text to describe number" What can I do to change the results? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date & number within a cell containing text
Try this:
="text to appear with date " & TEXT(Q5,"mm/dd/yyyy") or =INT(L5) & " text to describe number" Hope this helps. Pete On Apr 29, 1:57*pm, sam wrote: I'm trying to create cells in a worksheet which are text with calculated dates & numbers imported from other cells in the workbook. *My problem is that the date reverts to the numeric form & the numbers have many decimal places. I would like to retain the mm/dd/yyyy date format & display only whole numbers. *The formula I am using to import the information is: ="text to appear with date" & Q5 or =L5& " text to describe number" What can I do to change the results? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date & number within a cell containing text
="text to appear with date"&TEXT(Q5,"mm/dd/yyyy")
=INT(L5)& " text to describe number" Regards, Stefi €žsam€ť ezt Ă*rta: I'm trying to create cells in a worksheet which are text with calculated dates & numbers imported from other cells in the workbook. My problem is that the date reverts to the numeric form & the numbers have many decimal places. I would like to retain the mm/dd/yyyy date format & display only whole numbers. The formula I am using to import the information is: ="text to appear with date" & Q5 or =L5& " text to describe number" What can I do to change the results? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a numeric number in text format in another cell? | Excel Worksheet Functions | |||
| text and date format in a cell | Excel Discussion (Misc queries) | |||
| format a cell to accept a date or a whole number | Excel Discussion (Misc queries) | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| How to format cell with text and date. | Excel Discussion (Misc queries) | |||
Linear Mode
