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
Hi Azhar,
PFA the solution
Regards,
Andy
On Fri, May 7, 2010 at 10:27 AM, Azhar Rai wrote:
> Dear Members
>
> I was just trying to calculate a similer thing but could not. Please help
> me too.
>
> I need to add a certain number of years to a date and get the resulting
> date. HOW?
>
> Thanks
Hi Goldie,
PFA the solution.
Regards,
Aindril
On Thu, May 6, 2010 at 4:43 PM, dare2gold wrote:
> Dear Members,.,
>
> i want to know how to get a later date just by inserting present date
> into one column and getting the date we desire just by typing the no
> of days
>
> suppose i entered
Dear Members
I was just trying to calculate a similer thing but could not. Please help me
too.
I need to add a certain number of years to a date and get the resulting
date. HOW?
Thanks
AZHAR RAI
Skype: azhar.rai
On 6 May 2010 16:13, dare2gold wrote:
> Dear Members,.,
>
> i want to know how
Format Start Date and End Date cells using custom format (d.mm.)
Start Date (A1
Number of Days (B1)
End Date (C1)
C1 contains =A1+B1
Maggie
On May 6, 6:13 am, dare2gold wrote:
> Dear Members,.,
>
> i want to know how to get a later date just by inserting present date
> into one column and
Dear Members,.,
i want to know how to get a later date just by inserting present date
into one column and getting the date we desire just by typing the no
of days
suppose i entered 1.04.2010 29days the output should be 30.04.2010.
please tell me ...
thanks in anticipations
goldie
--
-
