Forum Discussion
K155LA3
Oct 12, 2023Copper Contributor
Format number
Hello, I need to format numbers for the SI system. I did it for integers. But I can’t think of anything with numbers less than one.
I don't need the whole range, three degrees are enough, as in the table.
1 Reply
- SnowMan55Bronze Contributor
Perhaps what you seek is covered here: A comprehensive guide to Number Formats in Excel - Excel Evolution . [cr] (the Carriage Return character) can be entered by
Alt+EnterCtrl+J. [edit: Sorry, Alt+Enter is for [LF], not for [CR])