Replace a number that ends in .0 with "nothing"
Rapha
-
Anonymous user -
Anonymous user -
Hello,
I'm having a lot of trouble removing the .0 from my files (for example, 19.0 --> 19).
I have already tried several techniques including:
- Find + Replace: but it doesn't work (weirdly it worked on Gsheet, and on a MacBook Pro it also worked - knowing that I'm using an HP under Windows)
- Custom number format: it didn't do anything
etc
Anyway, I suspect an anomaly in the settings.
Can you please help me with this?
I'm having a lot of trouble removing the .0 from my files (for example, 19.0 --> 19).
I have already tried several techniques including:
- Find + Replace: but it doesn't work (weirdly it worked on Gsheet, and on a MacBook Pro it also worked - knowing that I'm using an HP under Windows)
- Custom number format: it didn't do anything
etc
Anyway, I suspect an anomaly in the settings.
Can you please help me with this?
3 answers
Hello
Is this 19.0 numeric (the point would be the "comma"?)
In this case, it is impossible to replace it because it is not actually entered in the cell but displayed (format).
When you click on the relevant cell, what do you see (look at the input area at the top)?
If it's a formula, you just need to decrease the number of digits after the comma (oops, the point, sorry) with the button <- ,0
If it's a decimal separator issue (point = comma)
File menu, Options, Advanced Options, check/uncheck "use system separator"
Cheers
If the answer helped or fixed your issue: a little thank you, if it's resolved: click the green button at the top ;-)
Let him who has never opened a user manual throw the first mouse.
Is this 19.0 numeric (the point would be the "comma"?)
In this case, it is impossible to replace it because it is not actually entered in the cell but displayed (format).
When you click on the relevant cell, what do you see (look at the input area at the top)?
If it's a formula, you just need to decrease the number of digits after the comma (oops, the point, sorry) with the button <- ,0
If it's a decimal separator issue (point = comma)
File menu, Options, Advanced Options, check/uncheck "use system separator"
Cheers
If the answer helped or fixed your issue: a little thank you, if it's resolved: click the green button at the top ;-)
Let him who has never opened a user manual throw the first mouse.
If the file (correctly entered) comes from a system where the decimal is a point, it must automatically switch to a comma in a system where the decimal is a comma.
We know it is correctly entered (numeric format) if it aligns automatically to the right in the cell (unless a modified imposed format).
Otherwise, it aligns to the left... Pressing Enter in each cell must restore the entry (to the right).
If the character ' appears on the left in the input area, it's text... Replace ' with nothing (' is the apostrophe)
A+
We know it is correctly entered (numeric format) if it aligns automatically to the right in the cell (unless a modified imposed format).
Otherwise, it aligns to the left... Pressing Enter in each cell must restore the entry (to the right).
If the character ' appears on the left in the input area, it's text... Replace ' with nothing (' is the apostrophe)
A+
A+