Pre-format the cells as Text or type an apostrophe before 3MAR01


Gord Dibben Excel MVP

On Sun, 7 Nov 2004 16:39:02 -0800, BHellings
wrote:

We have changed our customer ID Numbers to include a single digit number
before a 3 letter code.
When I try to use these new codes Excel instantly changes the codes into
dates.
I have tried to change the cell format from general to number but it makes
no difference what formate should I be using
An example is as follows:
Customer Name: Mariah Security
Old code: MAR001
New Code: 3MAR01
The new code displays as the 3rd of March 2001 (Naturally)
The 3 which has been inserted represents Victoria so I cannot get around
using it as it is a directive from Head office.
Thsi is throwing my worksheets out.
Help
Bronwyn