| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates and numbers
I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g. C4 has 011 and D4 has a date value of 0702 (february 2007) when I use =D4&C4, i'd like to have 0702011, but I get 3911511 how can I have 0702011 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and numbers
=TEXT(D4,"yymm") & C4
-- Gary's Student gsnu200707 "be_mcwayne" wrote: I've got to put 2 numbers together. they are in different cells. on is a date vhile the other is a value e.g. C4 has 011 and D4 has a date value of 0702 (february 2007) when I use =D4&C4, i'd like to have 0702011, but I get 3911511 how can I have 0702011 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and numbers
I think you'll need a slight modification from GS's to get the number
in the right format: =TEXT(D4,"yymm") & TEXT(C4,"000") Hope this helps! Richard On 22 Feb, 10:06, Gary''s Student wrote: =TEXT(D4,"yymm") & C4 -- Gary's Student gsnu200707 "be_mcwayne" wrote: I've got to put 2 numbers together. they are in different cells. on is a date vhile the other is a value e.g. C4 has 011 and D4 has a date value of 0702 (february 2007) when I use =D4&C4, i'd like to have 0702011, but I get 3911511 how can I have 0702011- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and numbers
Thank you for the correction.
-- Gary's Student gsnu200707 "RichardSchollar" wrote: I think you'll need a slight modification from GS's to get the number in the right format: =TEXT(D4,"yymm") & TEXT(C4,"000") Hope this helps! Richard On 22 Feb, 10:06, Gary''s Student wrote: =TEXT(D4,"yymm") & C4 -- Gary's Student gsnu200707 "be_mcwayne" wrote: I've got to put 2 numbers together. they are in different cells. on is a date vhile the other is a value e.g. C4 has 011 and D4 has a date value of 0702 (february 2007) when I use =D4&C4, i'd like to have 0702011, but I get 3911511 how can I have 0702011- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does dividing numbers give me dates and not numbers? | Excel Discussion (Misc queries) | |||
| Numbers to dates | Excel Worksheet Functions | |||
| Numbers To Dates | Excel Discussion (Misc queries) | |||
| numbers to dates | Excel Discussion (Misc queries) | |||
| Dates to numbers | Excel Worksheet Functions | |||
Linear Mode
