Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make a cell return the formatted value in a text string (i.
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 |
#2
|
|||
|
|||
Hi
=TEXT(A1,"yymmdd")&" - "&B1 -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "n.almeida" wrote in message ... 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 |
#3
|
|||
|
|||
are you trying to subtract days months years??
n.almeida wrote: 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 |
#4
|
|||
|
|||
Thanks
"Arvi Laanemets" wrote: Hi =TEXT(A1,"yymmdd")&" - "&B1 -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "n.almeida" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |