format trouble

  • Thread starter Lost on the West Coast
  • Start date
L

Lost on the West Coast

cannot get excel to display date data in date format (have same problem in
next column with currency)?Invoice Invoice
Date Amount
1930
39272 7739
39286 1609.16
39308 335.5
39335 3000
39380 90
39401 200
39394 180
39415 501
 
L

Lost on the West Coast

can get turn the problem on and off with the Tools, options, Windows options
formulas box, but I do not know what else I am changing when using this
feature. Will research further in excel help menu.
 

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

Repeat headers only when data existss 1
If statement needed to solve 1
Formatting of Dates 1
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show 4
Formats Not Saving 1
Lookup from another sheet 9
Maintaining Cell Format in Query 2
accounting format problems 4

Top