excel 2002 cells with leading zeros

N

navigator 2

I have suddenly found that entering numbers into an exsiting spread or a new
spread sheet in a new book that the number always has 0.00 in front of the
number I typed. Every thing else then works with small number
If I use =and then the number the problem is over come
What I do not know is if I send the work book too other users do they get
the same problem
Any ideas please?
 
N

Niek Otten

Tools>Options>Edit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have suddenly found that entering numbers into an exsiting spread or a new
| spread sheet in a new book that the number always has 0.00 in front of the
| number I typed. Every thing else then works with small number
| If I use =and then the number the problem is over come
| What I do not know is if I send the work book too other users do they get
| the same problem
| Any ideas please?
|
 
N

navigator 2

Niek

That was quick and to the POINT. I must have accidentally selected the edit
feature doing something else

What time is it were you are?

All the best
nav 2
 
N

Niek Otten

It's 15:42. Maybe you would call that 3:42 PM?
And where you are?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Niek
|
| That was quick and to the POINT. I must have accidentally selected the edit
| feature doing something else
|
| What time is it were you are?
|
| All the best
| nav 2
| "Niek Otten" wrote:
|
| > Tools>Options>Edit tab, uncheck Fixed decimal
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have suddenly found that entering numbers into an exsiting spread or a new
| > | spread sheet in a new book that the number always has 0.00 in front of the
| > | number I typed. Every thing else then works with small number
| > | If I use =and then the number the problem is over come
| > | What I do not know is if I send the work book too other users do they get
| > | the same problem
| > | Any ideas please?
| > |
| >
| >
| >
 
N

navigator 2

Niek

I am in the UK but noticed that the date and time hearder was showing PST
last Saturday

Thanks
Over and out
 
Top