#1   Report Post  
Posted to microsoft.public.excel.misc
Chrisp
 
Posts: n/a
Default Data Entry


Is there a way to automatically have a decimal place when entering
numbers; similar to setting your calculator to automatcally put in a
second decimal place?


--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile: http://www.excelforum.com/member.php...fo&userid=6365
View this thread: http://www.excelforum.com/showthread...hreadid=501666

  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default Data Entry

Go to the Tools menu, choose Options, then the Edit tab. There,
check the Fixed Decimal setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chrisp"
wrote in message
...

Is there a way to automatically have a decimal place when
entering
numbers; similar to setting your calculator to automatcally put
in a
second decimal place?


--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile:
http://www.excelforum.com/member.php...fo&userid=6365
View this thread:
http://www.excelforum.com/showthread...hreadid=501666



  #3   Report Post  
Posted to microsoft.public.excel.misc
Chrisp
 
Posts: n/a
Default Data Entry


Thanks, this is exactly what I needed.


--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile: http://www.excelforum.com/member.php...fo&userid=6365
View this thread: http://www.excelforum.com/showthread...hreadid=501666

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula and Data Entry in a Single Cell Josh VM Excel Discussion (Misc queries) 1 October 21st 05 09:31 PM
data entry form Excel Aart Dijkzeul Excel Discussion (Misc queries) 1 September 25th 05 01:57 PM
How can I prevent loosing formula during data entry? Thomas Jacob Excel Discussion (Misc queries) 2 June 13th 05 01:06 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 06:33 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"