Forum Discussion
Cell Format
Hi, I need to know how do I set a cell, to divide by certain number, in orden to obtain automatically a division by this constant number. I need this because I'm working with physical magnitudes, an...
mmm I'm not sure, cause, what about if I want to put 1250m. How can I achieve that it shows me 1,25km? Thanks for the feedback, I really appreciate that.
As HansVogelaar suggests, once you type the 'm' you are doomed; you no longer have a number. To show the distance in km with decimal places you could use the custom number format
0.00, "km"on a computer set to English locale
Or, since Rodrigo uses comma as decimal separator, the custom number format
0,00. "km"
- Thanks. That is what I would have guessed, but I have no way of checking!
