Let's say I have an integer value of 950 (representing 950 cents) in cell A1 in an Excel 2010 spreadsheet. Is there a way to make Excel display this value as 9.50 (representing 9.50 dollars) in that same cell (A1) while still keeping the original integer value as 950, maybe by using a custom number format code?
Excel 2010: How to display a value in cents as dollars by using only cell formatting, not formulas
microsoft-excel-2010
Related Question
- Excel – How to get the displayed value of a cell in MS Excel ( for text that was converted to dates)
- Excel formats a String to Date in a CSV file. How to retain the original string value
- Excel : how to put a literal dot into a cell format
- Excel – in Excel I want trailing 0’s on a rounded value that ends up in a text formatted cell, how can I do that
Best Answer
Number format code you want is
The hash (#) is for optional extra digits and the slash (\) before the decimal point (.) makes it a literal text character instead of the default decimal point position marker. Zeroes (0) will display a zero regardless of how many digits there are in the number.