Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input a number to not display as a date
hello! I have ran into this problem a few times when I'm trying to get a
number to appear, i.e. 3-30, and it automatically changes it into a date, 30-Mar. I've gone in and formatted and reformated the cell as a general number and it automatically changes back to date....errrrrrrrr. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input a number to not display as a date
Enter it with a preceding apostrophe, '3-30. The apostrophe will show in the
formula bar but not in the cell, Regards, Alan. "Ms Veco Indiana" wrote in message ... hello! I have ran into this problem a few times when I'm trying to get a number to appear, i.e. 3-30, and it automatically changes it into a date, 30-Mar. I've gone in and formatted and reformated the cell as a general number and it automatically changes back to date....errrrrrrrr. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input a number to not display as a date
Thanks! I knew it was something like that! I'd tried " and ^ from Quattro,
but they kept appearing! Thanks! "Alan" wrote: Enter it with a preceding apostrophe, '3-30. The apostrophe will show in the formula bar but not in the cell, Regards, Alan. "Ms Veco Indiana" wrote in message ... hello! I have ran into this problem a few times when I'm trying to get a number to appear, i.e. 3-30, and it automatically changes it into a date, 30-Mar. I've gone in and formatted and reformated the cell as a general number and it automatically changes back to date....errrrrrrrr. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to find/display the date X number of days later? | Excel Worksheet Functions | |||
Cell display after input | Excel Discussion (Misc queries) | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How to display date as week number | Excel Discussion (Misc queries) | |||
Simple Question, display only part of a date in Number format | Excel Worksheet Functions |