google sheetsios
I have a cell with the value 2.2 that is being displayed as text. I’m unable to convert the value format from text to number.
Screenshot 1 shows that cell format is number
Screenshot 2 shows that using the type formula, the cell value type is text
type formula info:
https://support.google.com/docs/answer/3267375
I’m currently using Google Sheets v1.2019.46202 on iOS 13.1.3
With the following custom number format, you are able to decimal-align numbers in Google Sheets, even by using fonts that use kerning.
???.?????
custom number format
result
I've added this solution in an example file: Decimal-Aligned Numbers
The solution is quite simple. Press this button to increase the number of decimals:
Now it will show the correct amount of decimals:
Please be aware that this works only up to 15 digits. Beyond that, Google Spreadsheets will ignore the rest.
Best Answer
Both Google sheets and the
TYPEformula are correct giving the correct result.Your screenshots do not complement each other.
Were they to be right, when you have the format at
Number ->1.000,12the number returned should have been2.20and not2.2as shown here in your screenshots.Most likely your
Localeis wrong. Try changing it by going toFile->Spreadsheet settings.TIP: You can also test it by typing
2,2instead. Should you test this number withTYPEorISNUMBERyou will get the result for it being a number and not text.