Date Format in Spreadsheet different from menu bar how to fix?

G

Geoff

Using MS excel 2003, the date in spreadsheet is showing as NZ / Australia
format, the date in menu bar up top is showing in the American format.

How do we get them to be the same?
 
S

Sheeloo

'menu bar up top ' shows the format of your Computer (Windows?)
and the cell shows the Cell format

You can change the Cell format to dd/mm/yyyy or whatever you want...
Edit->Format Cells (I think).

If you want to change the system format then (if Windows) do it through
Control Panel->Date and Time
 
S

Suleman Peerzade

Hi,

You can also do it this way

Menubar>>Format>>Cells>>Number tab>>Date>>Regional settings

or

Right click on the cell>>FormatCells>>Number tab>>Date>>Regional settings
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 

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

Menu Bar disappear 1
date input 2
date format problem 1
Cannot get date to format correctly 1
Date format defaults to Custom 6
Cell Format - Date 2
MS Query and date format 3
Converting complex date format to normal date format in Excel 0

Top