If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
format change
I set up my cell format as "text" format before I type name of sample ID
(9920-2, 9920-8, 9920-15, ...). However, for 9920-2 and 9920-8, when I push "Enter" Xxcel changes my format from text to date and become Feb-02 and Aug-02. 9920-15 and those after remain the way I have set up. Can anyone tell me how to make Excel stop changing my format and just use text format I have set up. |
#2
|
|||
|
|||
format change
Try this:
Right click inside the chart select Chart Options Axes see that the "Time-scale" is not on choose "Automatic" or "Category" "Terry" wrote: I set up my cell format as "text" format before I type name of sample ID (9920-2, 9920-8, 9920-15, ...). However, for 9920-2 and 9920-8, when I push "Enter" Xxcel changes my format from text to date and become Feb-02 and Aug-02. 9920-15 and those after remain the way I have set up. Can anyone tell me how to make Excel stop changing my format and just use text format I have set up. |
#3
|
|||
|
|||
format change
I couldn't reproduce your problem. When I entered any of the three items
you showed, the cells continued to treat the values as text, not as dates. This occurred whether the number format was changed to Text or left as General. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Terry wrote: I set up my cell format as "text" format before I type name of sample ID (9920-2, 9920-8, 9920-15, ...). However, for 9920-2 and 9920-8, when I push "Enter" Xxcel changes my format from text to date and become Feb-02 and Aug-02. 9920-15 and those after remain the way I have set up. Can anyone tell me how to make Excel stop changing my format and just use text format I have set up. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
How can I change imported 20050131 format to 1/2005 format | Access Newbie looking for help | General Discussion | 4 | August 23rd, 2005 11:16 PM |
Change General Format to Currency Format | Freshman | Worksheet Functions | 3 | July 8th, 2005 03:42 AM |
Conditional format (word change) | Onion | Worksheet Functions | 0 | February 8th, 2005 07:29 PM |
Time: Change format | Sat | Worksheet Functions | 1 | February 4th, 2004 12:50 AM |