[Tfug] Turning off OOo auto-format?

Paul Scott waterhorse at ultrasw.com
Tue Sep 2 22:09:23 MST 2008


Claude Rubinson wrote:
> On Tue, Sep 02, 2008 at 07:39:56PM -0700, Malcolm Schmerl wrote:
>   
>> The sixth and seventh icons from the left in the third tool bar from the 
>> top allow you to specify how many decimal places to display a number. 
>> If, for example, you're displaying monetary figures, you'd always want 
>> them displayed with two decimal places.  Malcolm
>>     
>
> That's not what I want either.  Besides the fact that that info is
> saved with the document, that would render, e.g., Figure "1.9" as
> "1.90".  Which is, again, wrong.  What I'm looking to do is tell OOo
> to format everything as text unless I explicitly state otherwise.
>   
Do a Ctrl-A.  Select Format/Cells/Numbers/Text.  Then format any other
ranges the way you want them.

Paul Scott





More information about the tfug mailing list