Timeline for Using the Numbers app, how to make 2 plus +0.25 become 2.25?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 26, 2012 at 21:40 | comment | added | jtbandes |
You could do it all at once, perhaps something like =A1+VALUE(SUBSTITUTE(B1,...))?
|
|
| Jul 26, 2012 at 21:37 | comment | added | nonopolarity | so you mean, if I have a table that is 20 x 6 cells, then I have to copy and place another 20 x 6 cells on the same sheet (or probably on another sheet), with that formula to "translate" the numbers... so in a way, there will be double the real estate (area or cells) used? | |
| Jul 26, 2012 at 21:17 | history | answered | jtbandes | CC BY-SA 3.0 |