Using Rept function

[Guest]

I want to repeat one cells entry somewhere else in my (same) worksheet and have used the Rept function successfully. However, ifthe 1st cell (e.g. A3 is in date format like 12/12/2003, when I use the Rept A3,1 function in another cell (e.g.cell R3), it returns the date as a number (37967). What I want is for the date to be repeated exactly as is (12/12/2003 or whatever date is typed).
Can anyone help please

 

[Jim Rech]

Don't use the REPT function. Just enter =A3 and apply the date format you
want using Format, Cells if you do not automatically get it.

 

[Peo Sjoblom]

You can't unless you use text function.
Having said that, why are you using the REPT function?
If all that you want is the value in A3 you can use

=A3

as opposed to

=REPT(A3,1)

then format the same as in A3, or use

=TEXT(A3,"mm/dd/yyyy")

which will return the date like 12/12/2003 but it will be text which I
suppose is OK unless you are doing calculations

Dates in excel counts days since Jan 0 1900 and 12/12/03 is the same as
37967 days from 01/00/1900



--

Regards,

Peo Sjoblom

I want to repeat one cells entry somewhere else in my (same) worksheet and

have used the Rept function successfully. However, ifthe 1st cell (e.g. A3
is in date format like 12/12/2003, when I use the Rept A3,1 function in
another cell (e.g.cell R3), it returns the date as a number (37967). What I
want is for the date to be repeated exactly as is (12/12/2003 or whatever
date is typed).