Previous Topic Next Topic

Excel

Closed
haseeb - Feb 28, 2010 at 04:13 AM
 Geoph Parry - Feb 28, 2010 at 12:06 PM
Hello, if i enter in excel as 10-20 it showing me as 10 oct if i enter 20-30 it is giving me 20-30 plz solve my problem
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 28, 2010 at 05:20 AM
10-20 it is considering at date 10=oct and 20 as day of month


20-30 is not a date so it ignores it

depends what are you trying to do. If you want to make 10-20 to appear as 10-20, you can put a ' in front
or have the cell to be formatted as text
0
Geoph Parry
Feb 28, 2010 at 12:06 PM
Excel tries to guess the formatting for anything you enter. Numbers that might be dates 10/10 10/10/10, 10-10 usually get picked as dates. If you want it to show up without any formatting precede it with a single quote. '10/10 is treated as text.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses