Numbers

[russell_piper]

In excel I type a number such as 01234, and excel knocks of the first zero. How do I make it retain the number ?

 

[Andrew Poulsom]

Format the cell as 00000.

 

[eliW]

On 2002-10-16 05:06, Andrew Poulsom wrote:
Format the cell as 00000.

Or as TEXT

 

[applebyd]

Format the cells as Text.

You can still perform operations on the contents although using this method you need to use a general format cell for formulas.

The other way is a custom format but that seems to lock it to x digits and adds that amount of 0's

HTH
DaveA

 

[applebyd]

I don't believe this....

By the time I'd typed the post above the other two had appeared!

:wink:DaveA

 

[Andrew Poulsom]

applebyd,

Frustrating isn't it?

Maybe you need to go on a course on speed typing.

 

[eliW]

On 2002-10-16 05:35, Andrew Poulsom wrote:
applebyd,

Frustrating isn't it?

Maybe you need to go on a course on speed typing.

Or write short posts.

 

[sykes]

Hi russell_piper

What you need to do is..........

Blast! Too late again.

Sykes