| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format in Spreadsheet different from menu bar how to fix?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format in Spreadsheet different from menu bar how to fix?
'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 "Geoff" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format in Spreadsheet different from menu bar how to fix?
Yes that worked, but it was under regional settings in Control Panel.
Thanks "Sheeloo" wrote: '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 "Geoff" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format in Spreadsheet different from menu bar how to fix?
Sorry for the mistake...
"Geoff" wrote: Yes that worked, but it was under regional settings in Control Panel. Thanks "Sheeloo" wrote: '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 "Geoff" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format in Spreadsheet different from menu bar how to fix?
Hi,
You can also do it this way MenubarFormatCellsNumber tabDateRegional settings or Right click on the cellFormatCellsNumber tabDateRegional settings -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Geoff" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Menu ~ Source from Different Spreadsheet | Excel Worksheet Functions | |||
| drop-down menu in an excel spreadsheet | Excel Worksheet Functions | |||
| one column on my excel spreadsheet will NOT format the date | Excel Worksheet Functions | |||
| Can I project an Excel spreadsheet without the menu bar? | Excel Discussion (Misc queries) | |||
| Date format in spreadsheet | Excel Worksheet Functions | |||
Linear Mode
