How to make a cell return the formatted value in a text string (i.

N

n.almeida

I have a cell A1 with a date (say 01.Jan.2005). I format it to display
050101. I have a cell cell B1 with a code (say 101).
I want to join then in C1; =A1&" - "&B1; I expect the result 050101 - 101
but I get 38353 - 101.
I know that the number corresponds to serial number of that date in the
Excel. But I don't have any use for that number, what I want is the formatted
date
 

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

Referencing the values of multiple cells in conditinal formatting. 0
Show value from one cell in another cell if today falls between a date range 5
Conditional Formatting Formula 3
Adding cells until they are greater than a lookup cell and returning a value 1
find out specific month and year 1
Help with IF Function for times. 5
split range address into individual cell addresses 9
Show a cell's formula in text format in a linked cell 2

Top