OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

dashes to slashes

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting
View previous topic :: View next topic  
Author Message
LT72884
Newbie
Newbie


Joined: 23 Oct 2008
Posts: 3

PostPosted: Thu Oct 23, 2008 7:50 am    Post subject: dashes to slashes Reply with quote

Ello all.

Im here because i have an interesting question. I am in the IT department of heavy mining and construction equipment company. We use Open office here. Well one of my co workers has experienced an interesting phenomena. Every time she types 10-23-08, Office automatically changes it to 10/23/08. If she types 8.00, Office takes off the .00 and leaves the 8. We need it to have the dashes and the decimal points due to formatting of our invoices and other paper work.

How do i change that?

thanx
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Oct 23, 2008 8:23 am    Post subject: Reply with quote

For dates as you want them format the cell as Text (Format > Cells > Number tab & set Category = Text).

For 8.00 do the same but on the Number tab select Number and the format you want.
Back to top
View user's profile Send private message
LT72884
Newbie
Newbie


Joined: 23 Oct 2008
Posts: 3

PostPosted: Thu Oct 23, 2008 9:23 am    Post subject: Reply with quote

Is there a way to format it so that when we make a new document, i dont have to format>cells and what not? Is there a one time fix?

thanx
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Oct 23, 2008 9:49 am    Post subject: Reply with quote

Format it and save it as a template.
Back to top
View user's profile Send private message
LT72884
Newbie
Newbie


Joined: 23 Oct 2008
Posts: 3

PostPosted: Thu Oct 23, 2008 9:59 am    Post subject: Reply with quote

dang...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group