how do i get excel from turning this number 2-2100 in to Feb-00?
M MartinW Jan 10, 2008 #2 Hi Rob, Precede it with an apostrophe like this '2-2100 The apostrophe will show in the formula bar but not in the cell.. or preformat the cell as text. HTH Martin
Hi Rob, Precede it with an apostrophe like this '2-2100 The apostrophe will show in the formula bar but not in the cell.. or preformat the cell as text. HTH Martin
