•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
HALP! Excel for Mac is dropping two digits on six figure numbers.
In the first cells I have "100" and "sum=(I25+250)" ... which shows as 350 in the cell below.
In cell I29 [sorry I didn't capture the cell labels on the left side]... I enter "sum=(I25+250,000) but excel truncates the "250,000" to "250,0" and displays "350".
This problem is format agnostic [happens under "General" "Accounting" etc...]
I've never messed with any of the settings, as far as I know... Help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#Mac
#truncates
#format
#General
#Accounting
#six figure numbers
#sum
#cell
#settings
#display
#digits
#truncation