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

GKP in currency format

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
unclebirt
General User
General User


Joined: 02 Feb 2012
Posts: 5
Location: London, England

PostPosted: Mon Apr 16, 2012 12:52 am    Post subject: GKP in currency format Reply with quote

hi ,
i have a cell format set for british sterling as follows -:

£1,256

when i just tried to change the value from 1256 to 100
i get 1000 GKP as soon as i type the 1

absoultly no changes have been made to the spreadsheet

thanks
Back to top
View user's profile Send private message
unclebirt
General User
General User


Joined: 02 Feb 2012
Posts: 5
Location: London, England

PostPosted: Mon Apr 16, 2012 12:57 am    Post subject: solution but why reason for problem Reply with quote

i have founf where it is getting the GKP from - it is the name of a company,
but that is way down in the spreadsheet and is not in a currency format.

It never did this before - and the GKP has been there for a very long time -strange indeed
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Mon Apr 16, 2012 10:38 pm    Post subject: Reply with quote

Hi,

Switch off the AutoInput function under Tools --> Cell Content.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
unclebirt
General User
General User


Joined: 02 Feb 2012
Posts: 5
Location: London, England

PostPosted: Tue Apr 17, 2012 2:00 am    Post subject: Auto input Reply with quote

Thank you very much for that reply.

Admittedly i don't know the specifics of auto input

with Excel - sometime autoinput worked sometimes not,

my feeling was that the two cells involved had to be close to one another
or no vacant cells between.

i deleted the GKP since it was no longer required,
but it nice to know how to sort this out in future.

thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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