General discussion

Locked

Excel - Clearing formatted cells

By GJ2008 ·
Hi, I'm trying to enter 001, 002, etc in to a row of cells but the numbers keep changing back to 1, 2, etc. Is there anyway to change this so the numbers appear how I want to. I've already tried 'Edit, Clear Formats' but it didn't make any difference. Also, 'Format, Cells, Number is set to General'.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Don Christner In reply to Excel - Clearing formatte ...

Change the cell format to Text, numbers can't have leading zeroes.

Don

Collapse -

by GJ2008 In reply to

Poster rated this answer.

Collapse -

by DKlippert In reply to Excel - Clearing formatte ...

You can use a Custom format like
000 or 000#
Appending an ' will make the number text

Collapse -

by GJ2008 In reply to Excel - Clearing formatte ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums