Negative dates and times

  • Thread starter Thread starter Gavyn Milton
  • Start date Start date
G

Gavyn Milton

I need excel to display negative times. At present cells
display #######. Can I change this?

Thanks

Gavyn
 
Hi Gavyn,

I think you have to use the 1904 date system. Go Tools menu > Options...
command > Calculation tab > Select 1904 date system. But, if your workbook
has links to other workbooks that use the default 1900 date system, it could
cause erroneous results.

HTH
 
I need excel to display negative times. At present cells
display #######. Can I change this?
Click to expand...

As a workaround, could you format the cell as a number, absolute value it (or
* -1), then use a special format to show "-" time ? ... or do you need to
calculate with it a bit more ? :)

Bruce
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
To Display Negative Dates 2
Displaying negatives with (brackets) 3
Negative time displayed as ####### 8
A negative display watch 9
formatting negative numbers 1
Displaying negative time 8
Automatic display positive or negative 3

Back
Top