Currency number entered defaulting to pence value not pounds

David Brown · #1 05-11-2015, 01:40 PM

A friend of mine asked for my help as his Excel guru, but the problem I found is something I have never seen before, and was unable to solve, so I wondered whether anyone here would be able to help, please.

When he types a number, for instance "25", in an Excel cell which is formatted to show two decimal places, as soon as he hits enter it defaults to the fraction, rather than the whole number, so that instead of "25.00" he sees "0.25". This happens whether he selects "number" or "currency" as the cell format. Incidentally, if he selects "currency" but then opts for "none" as the currency symbol, it automatically returns to "number".

I believe he is using Office 2010.

Any ideas what is wrong and how to cure it, please?

gebobs · #2 05-13-2015, 06:27 AM

Quote:

Originally Posted by David Brown

When he types a number, for instance "25", in an Excel cell which is formatted to show two decimal places, as soon as he hits enter it defaults to the fraction, rather than the whole number, so that instead of "25.00" he sees "0.25".

Go to Options: Advanced and uncheck "Automatically insert a decimal point".

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
enter a constant based on entered number	So New2 This	Word VBA	1	10-17-2014 05:29 AM
Copying and pasting acount data into Excel as text will not reformat to a number or currency	ncbergst	Excel	3	09-04-2014 11:29 AM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM
Outlook search defaulting to "All Mail Items"???	Ninafel	Outlook	0	12-02-2010 02:01 PM
Making sure the correct number of characters are entered.	leroytrolley	Excel	1	07-25-2008 06:38 AM