How do I enter a decimal automatically without typing it every ti.

Hayley

Posts: n/a

How do I enter a decimal automatically without typing it every ti.

I want to enter data into cells and not have to type the decimal point every
time. Is there any way to do this? I know you can set the number of places
behind the decimal point, but it still means you have to type the point every
time.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be.	terrier	New Users to Excel	1	January 29th 05 10:59 AM
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be.	terrier	New Users to Excel	0	January 29th 05 06:11 AM
enter data in cell then run macro automatically	R D S	Excel Discussion (Misc queries)	2	January 25th 05 10:19 PM
Excel: How do I enter a date in one cell & automatically dates adj	Shannon	Excel Discussion (Misc queries)	4	January 12th 05 12:51 AM
Enter Data Into Another Excel File Automatically	Morrisg	Excel Worksheet Functions	0	January 11th 05 02:07 AM

All times are GMT +1. The time now is 05:32 AM.

Menu

About Us