G Guest Oct 27, 2005 #1 How do you insert the sequence "10-8-6" onto a worksheet without it automatically translating the format into the date 10/08/2006?
How do you insert the sequence "10-8-6" onto a worksheet without it automatically translating the format into the date 10/08/2006?
G Guest Oct 27, 2005 #3 Thanks Ian Ian said: Format the cell as Text before entering the data. Click to expand...
R Roger Govier Oct 27, 2005 #4 Hi Or, place a single quote ' before your entry. It won't show up in the cell, only in the formula bar, and will tell Excel to treat the value as text. Regards Roger Govier
Hi Or, place a single quote ' before your entry. It won't show up in the cell, only in the formula bar, and will tell Excel to treat the value as text. Regards Roger Govier
