Format cells as cents, e.g., .37 as 37¢

[bythecshore]

The title tells it all: how do I format a cell to show a decimal as cents? For example, instead of .37 I'd like it to show as 37¢.

thanks.

 

[Micron]

maybe like this

Display Values With Dollars And Cents Symbols - FREE Microsoft Excel Spreadsheet Tips and Tutorials

You can Double, Triple,even Quadruple your productivity in your Microsoft Excel. You'll be amazed at the time you'll save by learning just a few of these spreadsheet tips, shortcuts, and mini-tutorials.

www.theexceladdict.com

 

[snjpverma]

To format an Excel cell to show a decimal as cents, follow these steps:

1. Select the cell or range of cells you want to format.
2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, go to the "Number" tab.
4. In the Category list, select "Custom."
5. In the "Type" field, enter the following format code: 0.00"¢"
6. Click "OK" to apply the format.

This will format the cell(s) to show the decimal as cents, with the cents symbol (¢) added at the end.

 

[Micron]

That makes 1.37 look like 1.37¢ Might not be what is wanted, but we'll see.

 

[snjpverma]

That makes 1.37 look like 1.37¢ Might not be what is wanted, but we'll see.

The question suggests that OP wants that symbol in the end. Let's see if something else is required.

 

[awoohaw]

I just found this article that takes the decimal out:

Is there a custom format in excel to show cents values without a decimal

I would like to display 0.37 as 37¢, in Excel. I can do .37¢ with the format .00¢, but 00¢ doesn't work, cause it works with the whole number part. I know the percentage sign works with the next two

superuser.com

but basicall it says:
# ₵ CNTL-J %

never mind it does not seem to work.

 

[bythecshore]

To format an Excel cell to show a decimal as cents, follow these steps:

1. Select the cell or range of cells you want to format.
2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, go to the "Number" tab.
4. In the Category list, select "Custom."
5. In the "Type" field, enter the following format code: 0.00"¢"
6. Click "OK" to apply the format.

This will format the cell(s) to show the decimal as cents, with the cents symbol (¢) added at the end.

Yes, that pretty much does it. The decimal was in the wrong place, but I just multiplied the result by 10 and that did the trick. Thanks.

 

[snjpverma]

Glad it worked for you, and thanks for the feedback.