GKP in currency format

unclebirt · Posted: Mon Apr 16, 2012 12:52 am Post subject: GKP in currency format

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

unclebirt

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

mgroenescheij · Posted: Mon Apr 16, 2012 10:38 pm Post subject:

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).

unclebirt · Posted: Tue Apr 17, 2012 2:00 am Post subject: Auto input

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