General discussion
April 19, 2004 at 02:44 AM
gj2008

Excel – Clearing formatted cells

by gj2008 . Updated 22 years, 5 months ago

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 discussion is locked

All Comments