MS Excel help please

hanwellmike

!!!!!!'s solution is the correct one but maybe not detailed correctly.

Right click on the cell or row or column
Format
Custom
Type 6 zeroes in the box under ''Type:''

I am using Excel 2003

Stompa

Nile wrote: »

It doesn't when I enter 001299............I end up with 1299 again.

It should work fine, it does for me.

Stephen_Leak

Click on the cell with the little green flag, then on the exclamation mark in a diamond in a box that should appear to the left of it, and select "Ignore Error" from the drop down list.

Nile

Stephen_Leak wrote: »

Click on the cell with the little green flag, then on the exclamation mark in a diamond in a box that should appear to the left of it, and select "Ignore Error" from the drop down list.

BRILLIANT!:j:j

That works. I now have a number 001299 (not text or a label) with no green flag in the cell.:cool:

Thanks everyone for your help.:T

Dave_C_2

As an aside, you can still use a number shown as text in a calculation by using the VALUE function.

Dave