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
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
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