You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Enter 1 returns as .01, using decimal function can change displayed number to 0.1000, but not to integer 1. Changed in style same outcome. To display 1 must enter '1 or explicitly 1.0
Excel obviously talks to OS 10.15.5, passing it an integer and OS returns a real,, it would seem there is a matching error of data type. How is this repaired?
MacBook Pro 13″, macOS 10.15
Hey WayneAu,
Thank you for using Apple Support Communities!
We see from your post that you're having trouble with formatting numbers in Excel and we'd like to help out.
We'd suggest reaching out here for help with Excel:
Excel help & learning - Microsoft Support
Cheers!
Default number format in Mac OS
