#1
|
|||
|
|||
Currency number entered defaulting to pence value not pounds
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? |
#2
|
|||
|
|||
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 |