Re: $$Excel-Macros$$ Date formatting prob! help!

2013-09-20 Thread Sam Mathai Chacko
Hi mum, The 5 digit number is the equivalent value of the corresponding date in that cell. You should see the correct format if you press CTRL+` ` is normally found just about the TAB key Regards, Sam Mathai Chacko On Fri, Sep 20, 2013 at 8:31 PM, Dawn wrote: > Hi! > Im updating my skills in

Re: $$Excel-Macros$$ Date formatting prob! help!

2013-09-20 Thread De Premor
Try To Press Button CTRL + ` (a button before button "1", in the top of TAB button bellow the ESC ) :D Or Goto Menu Formula then deactivate Sub Menu "Show Formulas" On 20-09-2013 22:01, Dawn wrote: Hi! Im updating my skills in excel and have created a spreadsheet with heaps of dates in a col

$$Excel-Macros$$ Date formatting prob! help!

2013-09-20 Thread Dawn
Hi! Im updating my skills in excel and have created a spreadsheet with heaps of dates in a column. They have 'somehow' all changed to a five digit number! The original date can still be seen in the text bar at the top but doesn't appear in the cell. Ive tried to format the column back to a s