Bruce Lloyd wrote:
I was making a timetable in a *table *in a document in Writer and
having trouble getting time to show properly and wonder if there is a
way to change the configuration. The problem is when I want to write a
time as '8.30' Writer automatically truncates it to '8.3' if I use a
colon then Writer automatically makes it 8:30:00 (or was it 08:30:00)
which is equally unsatisfactory. The only way I could overcome the
problem was make the time '8.31' or use a comma '8,30'. If I needed
'8.00' it ended up as '8' unless I wrote it as '8,00'
I can't see why Writer bothers with such things as removing a zero from
the end of a decimal and presumably the problem/solution is in table
properties or Auto Correct or Auto Complete but I could not find it. It
doesn't seem to happen when 8.00 is written in text just in a table. Is
there something I can change?
regards
Bruce
Tables in Writer behave as a simple spreadsheet - you can control
formatting of numbers, dates, times, etc., and can use basic formulas.
They're not as powerful as Calc spreadsheets, but allow you to do the
basics within a Writer document without having to embed a spreadsheet.
Select the cells you want to format, then go to the Table menu > Number
Format and choose the format you want. e.g. you can display times as
08:30 rather than 08:30:00, or if you don't want the leading zero either
enter "H:MM" for the format code rather than "HH:MM" (it will still
display two digits if required).
Hope that helps.
Mark.
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
