REPT Function Excel 1

[WingandaPrayer]

Is there a function similar to REPT which will repeat Date/Time rather than Text.


Thanks


David

 

[SkipVought]

Hi,
Can you explain what this function does more completely? Skip,
metzgsk@voughtaircraft.com

 

[WingandaPrayer]

Skip,

If I use this as an example

Sheet 1
Cells
Row A
1 test
2 testing
3 etc

In Sheet 2 if I use the REPT function the cells will be copied from Sheet 1 to 2
REPT will only copy text.I'm looking for another one in Excel(sorry should have said before)to copy Date/Time as I enter data into a cell.

Thanks for the quick response.


David

 

[SkipVought]

Hi,
No function, but here's a formula...

=IF(LEFT(CELL("format",A1),1)="D",A1,"")

where A1 has the value to be "copied" -- only copies Date/Time formatted values. you will have to format the cell with the fornula as Date/Time

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[WingandaPrayer]

Skip,


Thanks for the help



David