Hi Louise

I don't think so. But there may be workaround that someone else knows.
The formula bar always shows the contents of the cell without any
formatting.
The cell displays the contents of the cell subject to whatever
formatting has been applied to that cell.

Regards

Roger Govier



Louise wrote:

Hi Roger

Thank you for your quick reply.

This has formatted the cells perfectly. Is there any way I can get it to
show the actual number in the formula bar too? For example, it still shows
97 instead of 00097.

Thanks again.

Louise

"Roger Govier" wrote:



Hi Louise

Try formating the cell NumberCustom0000 or as many digits as you need.

Regards

Roger Govier



Louise wrote:



Hi all

I have a large worksheet with lots of numbers on it beginning with 00,
however, whenever I enter a number, Excel automatically removes the zeros.

I have tried formatting the cells as General, Numbers but it still removes
the zeros. What can I do to get around this?? I realise I can put ' before
the numbers but I need them to be recognised as numbers, not text.

Thank you.

Louise