Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
I'm having trouble formatting dates in a office basic edition. I'm going about it how I normally would, eg. R click, format cells, date then selecting the one required, but it has no effect. I found the spreadsheet locked in protection so I unlocked it but this didn't help. -- geordy67 ------------------------------------------------------------------------ geordy67's Profile: http://www.excelforum.com/member.php...o&userid=36790 View this thread: http://www.excelforum.com/showthread...hreadid=565025 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
One possibility is that the "date" isn't a date recognized by Excel. Could be
just text. Perhaps you could paste some examples here in reply (copy the values direct from the formula bar) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "geordy67" wrote: I'm having trouble formatting dates in a office basic edition. I'm going about it how I normally would, eg. R click, format cells, date then selecting the one required, but it has no effect. I found the spreadsheet locked in protection so I unlocked it but this didn't help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
In past I would type in the date as 26/7/6 for eg. Excel would then auto redisplay it as 26/07/2006. Aligned to right It will work sometimes but mostly not. -- geordy67 ------------------------------------------------------------------------ geordy67's Profile: http://www.excelforum.com/member.php...o&userid=36790 View this thread: http://www.excelforum.com/showthread...hreadid=565025 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
"geordy67" wrote:
In past I would type in the date as 26/7/6 for eg. Excel would then auto redisplay it as 26/07/2006. Aligned to right It will work sometimes but mostly not. I'd usually type in entire dates, unambiguously, eg: 26 Jul 2006 Of course if the cell(s) were somehow pre-formatted as Text (unknown to us, of course), then Excel would not sense dates entered, irrespective how unambiguously these were entered. If this happens, we'd need to re-format the cells as general, then it'll be sensed. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
Clarification:
.. If this happens, we'd need to re-format the cells as general, then it'll be sensed. For new entry of dates, that is. For existing entries, we'd need to re-confirm the entry (eg click inside the formula bar, press ENTER) before it'd work. Merely reformatting the cells would not "fire" the sensing. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
Thanks for the help Max. I've tried reformatting the cells as general but still it will mostly display the date as typed and occasionally auto change to the full version eg. 27/7/2006 This is all in one column. I've tried formatting single cells and columns as a whole with no success. It's like there's some sort of background set up in there somewhere. -- geordy67 ------------------------------------------------------------------------ geordy67's Profile: http://www.excelforum.com/member.php...o&userid=36790 View this thread: http://www.excelforum.com/showthread...hreadid=565025 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble formatting date
"geordy67" wrote:
Thanks for the help Max. You're welcome .. I've tried reformatting the cells as general but still it will mostly display the date as typed and occasionally auto change to the full version eg. 27/7/2006 This is all in one column. I've tried formatting single cells and columns as a whole with no success. It's like there's some sort of background set up in there somewhere. Can you upload a small zipped sample and post the *link* to it in reply here? Then we could see exactly what's happening over there. I may not have the solution for you, but I will reply further to you here. Either way, pl let me know here whether you wish to pursue it further. (Kindly note that no attachments should be posted *directly* to the newsgroup) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formatting in Pivot Chart | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Date and time formatting | Excel Discussion (Misc queries) | |||
Incorrect Date formatting | Excel Discussion (Misc queries) | |||
problem with formatting cell to date format | Excel Worksheet Functions |