Solved cant keep 001 in that format in excel

March 6, 2012 at 23:21:08
Specs: Windows 7
DerbyDad I hope you can help I am trying to type 001 in excel I have tried all the formating...grrrr please help

See More: cant keep 001 in that format in excel

Report •


#1
March 7, 2012 at 00:14:27
✔ Best Answer
Change the format to 'TEXT' and then type 001. You might get an error, click on that exclamation and click Ignore...

I hope this will help...

Thanks,
Althaf


Report •

#2
March 7, 2012 at 08:42:24
putting a single inverted comma before the number has the same effect.

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •

Related Solutions


Ask Question