 |
 |
 |
 |
 |
 |
|
|
|
|
|
|
|
 |
11-15-2005, 12:55 AM
|
#1 |
|
40th Level Warrior
 Join Date: March 24, 2002
Posts: 10,215
|
I want to type 0325 on a cell but excel keep on changing it to 325. Is there anyway to prevent it from changing? This is so irritating...
|
|
|
|
11-15-2005, 01:39 AM
|
#2 |
|
Jack Burton
 Join Date: July 19, 2003
Location: an expat living in France
Age: 39
Posts: 5,577
|
Right click on the cell you have the number in, go to cell formatting or equivalent and there change the type to text. Then your numbers shall stay as text, and as you write them.
__________________
|
|
|
|
|
11-15-2005, 06:04 AM
|
#3 |
|
40th Level Warrior
Join Date: March 24, 2002
Posts: 10,215
|
Got it thanks!
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel question | ZFR | General Discussion | 2 | 03-28-2007 05:16 AM |
| Need to create a drop-down checklist box for EXCEL... | quietman1920 | General Discussion | 1 | 07-14-2005 02:25 PM |
| VBA in Excel | Jorath Calar | General Conversation Archives (11/2000 - 01/2005) | 5 | 02-10-2004 11:18 AM |
| Help with excel and logarithmic scales | philip | General Conversation Archives (11/2000 - 01/2005) | 8 | 12-31-2003 07:22 PM |
| Excel...Some Help Needed... | FelixJaeger | General Conversation Archives (11/2000 - 01/2005) | 4 | 04-22-2003 08:58 AM |
