Discussion Locked
Excel - Clearing formatted cells
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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'.