Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I cant write 1.1 in Excel 2003. Always when I do that it changes to "1.jan"
Then when i try to format the cell to general, number or anything else it changes to 39448. Please tell me how i can write 1.1 in excel without it changing into 39448 or tell me how i can delete date formats out of Excel so I can use it....... I am using a list of numbers that update automatically from a website, but it gives all the values out as "1.1" or "11.3" or something like that but they all change into dates which changes into random date-formated numbers I cant use. Also, if anyone knows. How Can I change 1.1 to 1,1(a number i can use for calculations) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |