Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
Hi,
I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? Greets, Gunti |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
Hi,
Try this with a date in C1 =" Hi my name is "& TEXT(C1,"DD-MM-YYYY") &" and this is my question" Mike "Gunti" wrote: Hi, I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? Greets, Gunti |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
Use TEXT to format the date to taste, eg:
="The date is: "&TEXT(B2,"dd-mmm-yyyy") Likewise for formatting numbers to a certain x dp =TEXT(A1,"0.00") -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Gunti" wrote: I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
="how are you: " & c1 & "on: " & text(d1,"mm/dd/yyyy") & char(10) &
"remember you owe me: " & text(e1,"$#,##0.00") & "!" The char(10) is an alt-enter character. So format the cell to allow wraptext if you use it. Gunti wrote: Hi, I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? Greets, Gunti -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
With a date in A1, try this:
="Today's date is " & TEXT(A1,"mmmm d, yyyy") The format string at the end of the TEXT function can be varied to suit your requirements, eg "dd/mm/yy" or "mm/dd/yyyy" or "mmm dd, yyyy" etc. You can use TEXT for numbers as well: ="You've scored " & TEXT(A2,"0.00") & " points" will take a numeric value in A2 and display it with 2 decimal places. Hope this helps. Pete On Jan 26, 1:23*pm, Gunti wrote: Hi, I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? Greets, Gunti |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
Quick and right answer. Cheers guys!
Gunti "Max" wrote: Use TEXT to format the date to taste, eg: ="The date is: "&TEXT(B2,"dd-mmm-yyyy") Likewise for formatting numbers to a certain x dp =TEXT(A1,"0.00") -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Gunti" wrote: I'm aware i can refer pieces of text through: C1 = Gunti =" Hi my name is "& C1 &" and this is my question" I've got a question, i've often enough had the trouble of putting a date in there. It somehow doesn't get the date format though - it puts the excel date value in there. It also happens that it doesn't round the number to an amount i want it to. How can i format these type of cells? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding referring to different cell Value
Welcome, pl mark ALL responses which help by clicking the YES buttons below.
Thanks -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Gunti" wrote: Quick and right answer. Cheers guys! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to first cell in a range | Excel Discussion (Misc queries) | |||
Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
How to return a value Referring to the other cell. | Excel Worksheet Functions | |||
cell text referring to tab name | Excel Worksheet Functions |