Thread: [Solved] Currency number entered defaulting to pence value not pounds
View Single Post
 
Old 05-13-2015, 06:27 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by David Brown View Post
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".
Reply With Quote