Help me with excel 2003
Closed
grace
-
Mar 22, 2011 at 02:23 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 22, 2011 at 03:53 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 22, 2011 at 03:53 AM
Related:
- Help me with excel 2003
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
7 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:33 AM
Mar 22, 2011 at 02:33 AM
Use the following formula in g6:
=IF(d6<39234,e6*5.15%,e6*10.3%)
39234 is General value of Date 1-Jun-2007
=IF(d6<39234,e6*5.15%,e6*10.3%)
39234 is General value of Date 1-Jun-2007
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:45 AM
Mar 22, 2011 at 02:45 AM
enter the date
right click on the cell
click format cell
a pop-up window of format cells opened
now click general on the Number tab
it will show you the general value of date
right click on the cell
click format cell
a pop-up window of format cells opened
now click general on the Number tab
it will show you the general value of date
Didn't find the answer you are looking for?
Ask a question
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 02:59 AM
Mar 22, 2011 at 02:59 AM
the system is not reading it as date,
chage 31/5/2007 as
31/05/2007 if it works that great, otherwise
try in this form
mm/dd/yyyy
means
05/31/2007
chage 31/5/2007 as
31/05/2007 if it works that great, otherwise
try in this form
mm/dd/yyyy
means
05/31/2007
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 22, 2011 at 03:53 AM
Mar 22, 2011 at 03:53 AM
Do this:
1) First change your format to the specific date that you want for your column of data.
2) With the column selected, select "Copy"
3) Open notepad (NOT WORD, it has to be notepad)
4) Paste your data into notepad.
5) In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
6) Paste data back into Excel.
7) It will say something about size not being the same, paste it anyways.
after that you can check general value.
1) First change your format to the specific date that you want for your column of data.
2) With the column selected, select "Copy"
3) Open notepad (NOT WORD, it has to be notepad)
4) Paste your data into notepad.
5) In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
6) Paste data back into Excel.
7) It will say something about size not being the same, paste it anyways.
after that you can check general value.
