Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every time I type 24-7 it changes to 24/Jul no matter what
I cannot type 24-7 and leave the cell no matter what I change the format to,
it alway shanges back to date. It is getting very frustrating! the only way I can stop it is by putting a full stop, and this looks stupid! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every time I type 24-7 it changes to 24/Jul no matter what
Start off with a leading apostrpohe which won't show.
'24-7 Or, format the cell as Text first. Bob Umlas Excel MVP "James-Holland" wrote in message ... I cannot type 24-7 and leave the cell no matter what I change the format to, it alway shanges back to date. It is getting very frustrating! the only way I can stop it is by putting a full stop, and this looks stupid! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Every time I type 24-7 it changes to 24/Jul no matter what
Bob Umlas has given a correct answer and short, but if you want to sort out
your data/ or information by date you will not be able to sort it. Allways format you dates by using the menu FORMAT and change as you like or choose the format you like. the following will change you date to 24-7 and you are able to sort it by date. Before you start make sure the cells you want to format are highlighted then. Click on the menu FORMAT,CELLS, the NUMBER menu is already showing on the screen, use the arrow to scroll down to the menu called CUSTOM. Click or insert with your mouse in the box named TYPE: and delete the format in the box , which looks jibirish. THEN insert or type your new format as dd-mm then click O.K. to accept the changes. Hope the instructions are clear to follow. Hope this helps. Regards MariaC "James-Holland" wrote: I cannot type 24-7 and leave the cell no matter what I change the format to, it alway shanges back to date. It is getting very frustrating! the only way I can stop it is by putting a full stop, and this looks stupid! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
how do i type a time into a cell formatted for time? | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |