2007-05-26 01:21:50 · 4 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
Even changing the format to general has the same problem, either change that to text or type a single quote and then 01('01). Excel will not show the ' in the cell but it will in the formula bar.
2007-05-26 01:33:22 · answer #1 · answered by Ram82 1 · 0⤊ 0⤋
The cell format can be changed to do what you want.
Go to Format and select cells. From this select the tab Number. You will see several options - including dates, etc. Go to custom and select what you wish. Note there are several custom choices and you may need to experiment until you understand what they are trying to describe.
2007-05-26 08:28:49 · answer #2 · answered by GTB 7 · 0⤊ 0⤋
you could type it as a text item by putting a ' in front of the 01
2007-05-26 08:30:40 · answer #3 · answered by The Jade Merchant 4 · 0⤊ 0⤋
Change the format of the cell in question to General
2007-05-26 08:24:53 · answer #4 · answered by MLM 7 · 0⤊ 0⤋