cloudburst7
Thread Starter
- Joined
- Aug 31, 2008
- Messages
- 156
I have a table in which the first column is numbers. Sometimes there is a range eg 3-4 in which Calc auto changes it to a date eg 3-4 becomes 03/04/08
I've tried rummaging through its menus but can't find the solution. Changing the date format for a particular cell makes that cell look ok, but I'd have to do that for individual cells becuase copying it to the whole column spoils those cells which contain a single digit, not a range.
I'm sure there's an obvious solution, but right now I can't find it. Any help will be much appreciated!
Edited to add:
Changing the cell format to text, or All, to avoid it being read as a number, does somethign even stranger, eg 4-5 is changed to 39572
I've tried rummaging through its menus but can't find the solution. Changing the date format for a particular cell makes that cell look ok, but I'd have to do that for individual cells becuase copying it to the whole column spoils those cells which contain a single digit, not a range.
I'm sure there's an obvious solution, but right now I can't find it. Any help will be much appreciated!
Edited to add:
Changing the cell format to text, or All, to avoid it being read as a number, does somethign even stranger, eg 4-5 is changed to 39572