Excel date formatting

G

Glen_W

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have formatted the cells to yield a date in the form 14-Mar. If I input 3/4 or 3-4 the cell yields 4-Mar. It will not allow me to enter the data in the same format I want it the data output. If I enter 30/11 I expect to get 30-Nov, but I do not. It seems logical to me that I should be able to input the date in the same format as I want it output. Can this be done?
 
C

CyberTaz

It's a matter of your System Preferences settings - Excel takes its cue from
that. Change your International preference for Formats & Excel will function
that way starting with the next launch of the program.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Creating a Search using a combo box and then creating a report. 4
Removing a repeated words 0
Countdown macro - display settings 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
date format in sheets 1
Found few bugs in my daily routine of work in excel for MAC 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Found few bugs in my daily routine of work in excel for MAC 0

Top