Spreadsheet Help

Twigglish

Member

​

Joined

Jul 23, 2007

Location

Clarksville, TN

• Sep 18, 2007

• #1

When putting "Monday 10/1" into a cell, it changes it into normal "dd/mm/yy". I need it to stay how I type it in. Any help?
Im using OpenOffice.

 

RollingThunder

Destroyer of Trolls & Spammers

​

​

Joined

Jan 7, 2005

• Sep 18, 2007

• #2

Twigglish said:

When putting "Monday 10/1" into a cell, it changes it into normal "dd/mm/yy". I need it to stay how I type it in. Any help?
Im using OpenOffice.

Click to expand...

Twig,

Format the cell as "text."

 

MRD

Senior Member

​

Joined

Feb 14, 2003

• Sep 18, 2007

• #3

After you enter the text, choose format, cell and enter the format code in the line at the bottom "NNNN MM/DD" and it should display what you want.

 

OP

Twigglish

Member

​

Joined

Jul 23, 2007

Location

Clarksville, TN

• Sep 18, 2007

• Thread Starter
• #4

Thank you guys.