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

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

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?

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

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

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?

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!