Hello,

how can I paste an negative time for excample -5:00 from one exce
sheet to a other sheet.

When I paste "-5:00", I'll get “#############” which is equal t
"-0,208333333333"


Currently, I use the PateSpecial-Function, xlPasteValues.

What can I do? Where is my mistake?

XL has no problem displaying negative times using the 1904 date system
(MacXL default) - choose Tools/Custom/Calculation, check the 1904 Date
I don’t find this!

When I use PasteSpecial xlPasteFormats after PasteSpecia
xlPasteValues. It is not working.

When I use a custom format of:
hh:mm:ss, It is also not working out.

Regards,

Sylvia

--
Sylvia
-----------------------------------------------------------------------
Sylvian's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=39983