| View previous topic :: View next topic |
| Author |
Message |
Sheelos
Power User
Joined: 12 Jul 2005
Posts: 56
Location: Melbourne, Australia
|
 Posted: Wed Aug 31, 2005 11:28 pm Post subject: Date format in cell |
 |
|
Hi all,
I have a particular cell in a spreadsheet which no matter how I format it, enters a date value when you type in the number "2" any other number works fine, when I type 2 it autocompletes with a date then when I hit enter it converts the date into a number (38590 to be exact)
the locale settings look ok and I tried disabling all the auto correct features but nothing seems to work.
suggestions anyone? |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Sep 01, 2005 3:43 am Post subject: Re: Date format in cell |
|
|
| Sheelos wrote: | Hi all,
I have a particular cell in a spreadsheet which no matter how I format it, enters a date value when you type in the number "2" any other number works fine, when I type 2 it autocompletes with a date then when I hit enter it converts the date into a number (38590 to be exact)
the locale settings look ok and I tried disabling all the auto correct features but nothing seems to work.
suggestions anyone? |
Better you than me  How about a brute force approach? Delete the cell and insert a new one. It might work.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands
|
| Posted: Thu Sep 01, 2005 4:59 am Post subject: |
|
|
Select the cell
Choose Format > Cellformat on the Numbers tab select Text under Category
should do the trick
DiGro |
|
| Back to top |
|
|
|
