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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

8 points

4 questions about numbers

Are there any faster method to put todays date into a cell other than typing on mac?
How can I make a sum with text in the cell? (Text before and also after the sum)
Are there any method to divide a number by 2 (or cut in half) in a cell? For example I want to make 3 to 1,5
Are there any method to write one smaller number next to the other? For example if I write 4,45 I want to see 3,45 automatically in the cell next to the cell which contains 4,45

Thanks for any help!

Posted on Nov 2, 2022 6:34 PM

Top-ranking reply

Level 7

27,982 points

Posted on Nov 2, 2022 7:17 PM

Use the keyboard shortcut for the menu item Table->Insert Current Date. I set mine to Shift Command D. I forget what it was originally.
The formula would be of the form ="The total is "&SUM(B2:B24)&" Units"
I think in Excel you can do something like that to selected cell(s). In Numbers it requires doing the math in another column then using Copy followed by Paste Formula Results to get the results back to the original column (assuming it is a column of values you want to do this to).
If cell B2 has the value 4,45 and cell C2 has the formula =B2-1 , the formula result in B2 will be 3,45

View in context

Similar questions