Automatic decimal point
 

Years ago I used a spreadsheet program which allowed me to setup an option
for the decimal point so that when I entered a number: 123456, it would
automatically convert to 1,234.56.
I do not see where or how to do this in Excel. In my line of work, this
would be of get help to me. I hope someone can assist me with this. Thanks,
--
rshfl

Automatic decimal point
 

Tools Options... Edit Fixed ecimal 2

Use Format Cells... to get the comma
--
Gary''s Student - gsnu200856


"Ron H" wrote:

Years ago I used a spreadsheet program which allowed me to setup an option
for the decimal point so that when I entered a number: 123456, it would
automatically convert to 1,234.56.
I do not see where or how to do this in Excel. In my line of work, this
would be of get help to me. I hope someone can assist me with this. Thanks,
--
rshfl

Automatic decimal point
 

Excel 2007

Home ButtonExcel OptionsAdvancedEditing Options Checkmark
"Automatically insert a decimal point" and set for 2


Gord Dibben MS Excel MVP

On Sat, 6 Jun 2009 05:52:08 -0700, Ron H
wrote:

Years ago I used a spreadsheet program which allowed me to setup an option
for the decimal point so that when I entered a number: 123456, it would
automatically convert to 1,234.56.
I do not see where or how to do this in Excel. In my line of work, this
would be of get help to me. I hope someone can assist me with this. Thanks,