| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date showing as numeric value in a text string formula
Cell [A1]
= " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &$D$5 Cell [C1} = 5,000 Cell [D5] = 05/05/07 This cell is in date format. Cell [A1] value (results) show up in cell [A3]. I can't get [A3] to show the date in date format. It shows up as 39207. Show below: The 5,000 widgets are for sale. However they expire on 39207. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date showing as numeric value in a text string formula
Do the same as you did for the widget cell and wrap it in the TEXT function
but use "mm/dd/yy" instead I noticed that you have a dollar sign in the TEXT function in the formula you posted, if these are number of widgets then you should remove the dollar sign -- Regards, Peo Sjoblom "dj479794" wrote in message ... Cell [A1] = " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &$D$5 Cell [C1} = 5,000 Cell [D5] = 05/05/07 This cell is in date format. Cell [A1] value (results) show up in cell [A3]. I can't get [A3] to show the date in date format. It shows up as 39207. Show below: The 5,000 widgets are for sale. However they expire on 39207. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date showing as numeric value in a text string formula
....expire on " & text($d$5,"mm/dd/yyyy") & "."
dj479794 wrote: Cell [A1] = " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &$D$5 Cell [C1} = 5,000 Cell [D5] = 05/05/07 This cell is in date format. Cell [A1] value (results) show up in cell [A3]. I can't get [A3] to show the date in date format. It shows up as 39207. Show below: The 5,000 widgets are for sale. However they expire on 39207. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date showing as numeric value in a text string formula
You have use another TEXT function:
= " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &TEXT($D$5,"mm/dd/yy") -- Biff Microsoft Excel MVP "dj479794" wrote in message ... Cell [A1] = " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &$D$5 Cell [C1} = 5,000 Cell [D5] = 05/05/07 This cell is in date format. Cell [A1] value (results) show up in cell [A3]. I can't get [A3] to show the date in date format. It shows up as 39207. Show below: The 5,000 widgets are for sale. However they expire on 39207. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date showing as numeric value in a text string formula
= " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on "
&TEXT($D$5,"mmmm d yyyy") Gord Dibben MS Excel MVP On Mon, 2 Jul 2007 14:08:03 -0700, dj479794 wrote: Cell [A1] = " The " &TEXT(C1,"$#,###") & " widgets are for sale. However they expire on " &$D$5 Cell [C1} = 5,000 Cell [D5] = 05/05/07 This cell is in date format. Cell [A1] value (results) show up in cell [A3]. I can't get [A3] to show the date in date format. It shows up as 39207. Show below: The 5,000 widgets are for sale. However they expire on 39207. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| equation as text string and its numeric result | Excel Discussion (Misc queries) | |||
| Remove Numeric from a Text String - Help? | Excel Discussion (Misc queries) | |||
| Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
| Extrapolate numeric values from text string | Excel Worksheet Functions | |||
| Find first numeric value in text string | Excel Worksheet Functions | |||
Hybrid Mode
