Currency number entered defaulting to pence value not pounds

		Microsoft Office Forums > Microsoft Excel > Excel
Currency number entered defaulting to pence value not pounds

FAQ

Thread Tools

Display Modes

05-13-2015, 06:27 AM

gebobs

Windows 7 64bit Currency number entered defaulting to pence value not pounds

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 PM.