Welcome to NeoOffice developer notes and announcements
Developer notes and announcements

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website

· Forums
· NeoOffice Support
· NeoWiki

· Twitter @NeoOffice

· Download NeoOffice

NeoOffice :: View topic - Time formatting
Time formatting
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message

PostPosted: Fri Jul 16, 2004 4:36 am    Post subject: Time formatting

I can't get my preferred time format to stick in Calc.

I would like to display times like this: 933p

So here is what I do:
1. Type 21:33 in a cell. It shows up as 21:33:00.
2. Format the cell as hmma/p to have it display as 933p

So far so good. But if I save the file as .sxc, then close and reopen it, the cell displays as 933pm. The extra character has also been added to the format in the Format Cells dialog box.

This does work in Excel, and it works in Calc if I use .xls format, but not with .sxc format. I don't know whether it's a Neo/J issue or an OOo issue.
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

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
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.