Question regarding referring to different cell Value

G

Gunti

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
 
M

Mike H

Hi,

Try this with a date in C1

=" Hi my name is "& TEXT(C1,"DD-MM-YYYY") &" and this is my question"

Mike
 
D

Dave Peterson

="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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Macro Question 17
Questing regarding Date Stamp 2
Some formatting (control) questions 5
Sumproductlike in Access 1
Compare the value of one cell to 2 different cells 4
Entering a cell with Criterias 5
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
setting cell values based on a 3rd cell 4

Top