Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-17-2018, 08:12 PM
nm5040 nm5040 is offline Mac OS X Office 2019
Novice
 
Join Date: Dec 2018
Posts: 3
nm5040 is on a distinguished road
Default trying to get whole numbers for currency

I am not very experienced at using Excel, and only use it for simple spreadsheets. I just updated to the new MS Office 2019 from the Mac 2011 version and have run into a problem that did not happen in my old version. My brother-in-law, who is very experienced in Excel, who just has purchased a new version of MS Office 365, does not have this problem and doesn't know how to solve it.

In entering values in my financial spreadsheet in the new version, I cannot get it to record the numbers, as currency, that I put in exactly as I put them in. I have gone into format in numbers and chose currency and no decimals. But when I enter a number in a cell, it automatically assumes that there is a decimal in the number, and then rounds it to the nearest number. For instance, if I type 78 into a cell (for $78), the bar above will record .78 and the cell will show $1 (rounding up from .78). I want to be able to enter a number (for currency) and have the cell show exactly what I entered - $78 if I typed in 78. I don't want to have to type $78.00 for all whole dollars. (I would also like it to show $78.50 if that is what I typed, but that is not the major problem, as I generally do not enter cents in my spreadsheet.). I'm sure that this is a setting somewhere, but I have searched and not found it.

thank you for any suggestions or solutions
Nancy
Reply With Quote
  #2  
Old 12-17-2018, 09:54 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Click File, then Options, then Advanced, remove the tick at 'Automatically insert a decimal point', OK.
Reply With Quote
  #3  
Old 12-18-2018, 06:29 PM
nm5040 nm5040 is offline Mac OS X Office 2019
Novice
 
Join Date: Dec 2018
Posts: 3
nm5040 is on a distinguished road
Default

I do not have "Options" under my File menu. I could list what I do have, but none of the choices is Options.
Reply With Quote
  #4  
Old 12-18-2018, 07:05 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Pardon me.
Only now I see that you use Mac, and I have absolutely no knowledge of that.

What I wrote in #2 works for me (Windows 10 and Office 365).
Reply With Quote
  #5  
Old 12-18-2018, 07:18 PM
nm5040 nm5040 is offline Mac OS X Office 2019
Novice
 
Join Date: Dec 2018
Posts: 3
nm5040 is on a distinguished road
Default

Thank for trying anyway. About 5 minutes ago, I found the solution - by searching through every menu, etc. Under Preferences, Edit, Edit Options, Display this number of decimals left unchecked. Then I seems that I can put in as decimal if I want ($78.59), but if I don't then I can get $78 and not the .78 rounding to 1. It seems to me somewhat counterintuitive to have to set number of decimals under both Preferences and Format/number, but I guess if I have it way I want it, it's good.
Thanks again, Nancy
Reply With Quote
Reply

Tags
currency, decimals, whole numbers

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates automatically changed to currency?! LRiver Excel 1 08-18-2017 02:42 PM
Currency Field not showing $ and is rounding Juliesctt Mail Merge 3 07-05-2016 06:43 PM
concatenate the currency too isasa74 Excel Programming 24 12-20-2015 06:01 AM
Currency format in form travelred Word 2 11-14-2014 06:15 AM
change currency $ to on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM


All times are GMT -7. The time now is 06:52 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft