format for curanncy without typing decimal

A

Aln54

Is there a way I can format my numbers so when I enter 12345 they will show
as 123.45 without me having to enter the decimal?
 
G

garfield-n-odie

In Excel, click on Tools | Options | Edit | check the "Fixed decimal
places" box and set the number of decimal places to 2 | OK.
 
A

Aln54

Thank you very much!!! I just needed someone that didn't have a senior memory!!
Thanks Again. Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
How to format without decimal point unless significant digits? 3
Formatting currency 4
Inconsistent formatting of section numbers 0
Setting length of data in Excel 1
Default format type HTML Outlook 2013 0
Using project as a resource tracker 0

Top