Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want formulas!
Okay, is there any way I can disable formulas? I don't need them, and it's
frustrating when I use a dash as a placeholder (-) and it starts to make a formula. I'm making a spreadsheet that has appointment times on it and such. Another thing it does is when I put that an appt is from 8-11, it decides that I mean August 11. I changed the property of that column to time, but then if I put 9-1, it thinks I mean 1 am. Is there any way to make it not care about am or pm, because I think I can figure it out without putting 13 for 1 pm. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want formulas!
A simple way to accomplish what you want would be to first highlight all the
cells in the range where you'd like the non-formula data to go, then right-click within the highlighted area and select "Format cells...", then click on the "Number" tab and select the "Category:" of "Text". This makes all the cells in that range text only cells. So, now, if you enter "8-11", it remains, "8-11". Hope this helps. Paul "dramajuana" wrote: Okay, is there any way I can disable formulas? I don't need them, and it's frustrating when I use a dash as a placeholder (-) and it starts to make a formula. I'm making a spreadsheet that has appointment times on it and such. Another thing it does is when I put that an appt is from 8-11, it decides that I mean August 11. I changed the property of that column to time, but then if I put 9-1, it thinks I mean 1 am. Is there any way to make it not care about am or pm, because I think I can figure it out without putting 13 for 1 pm. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want formulas!
Preformat the cell as Text (format|cells|number tab)
or start with a leading apostrophe: '-yourtexthere If you type times: 09:00 or 1:00 PM You'll have fewer problems. dramajuana wrote: Okay, is there any way I can disable formulas? I don't need them, and it's frustrating when I use a dash as a placeholder (-) and it starts to make a formula. I'm making a spreadsheet that has appointment times on it and such. Another thing it does is when I put that an appt is from 8-11, it decides that I mean August 11. I changed the property of that column to time, but then if I put 9-1, it thinks I mean 1 am. Is there any way to make it not care about am or pm, because I think I can figure it out without putting 13 for 1 pm. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want formulas!
Thanks for the apostrophe tip. That helps.
Yeah, I figured that out with the times. I'm just lazy and was looking for a way to save a half a second. "Dave Peterson" wrote: Preformat the cell as Text (format|cells|number tab) or start with a leading apostrophe: '-yourtexthere If you type times: 09:00 or 1:00 PM You'll have fewer problems. dramajuana wrote: Okay, is there any way I can disable formulas? I don't need them, and it's frustrating when I use a dash as a placeholder (-) and it starts to make a formula. I'm making a spreadsheet that has appointment times on it and such. Another thing it does is when I put that an appt is from 8-11, it decides that I mean August 11. I changed the property of that column to time, but then if I put 9-1, it thinks I mean 1 am. Is there any way to make it not care about am or pm, because I think I can figure it out without putting 13 for 1 pm. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want formulas!
dramajuana
find "option to prevent Excel changing 1-2-3 to a date" and agree with the suggestion. -- Vince "dramajuana" wrote: Okay, is there any way I can disable formulas? I don't need them, and it's frustrating when I use a dash as a placeholder (-) and it starts to make a formula. I'm making a spreadsheet that has appointment times on it and such. Another thing it does is when I put that an appt is from 8-11, it decides that I mean August 11. I changed the property of that column to time, but then if I put 9-1, it thinks I mean 1 am. Is there any way to make it not care about am or pm, because I think I can figure it out without putting 13 for 1 pm. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |