Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hayley
 
Posts: n/a
Default 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.

  #2   Report Post  
Max
 
Posts: n/a
Default

There's an option you can set ..
Click Tools Options Edit tab
Check Fixed decimal 2 places
Click OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Hayley" wrote in message
...
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.



  #3   Report Post  
Max
 
Posts: n/a
Default

Line should read as:
Check Fixed decimal 2 places (say)


--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


  #4   Report Post  
Hayley
 
Posts: n/a
Default

Max, thank you. That is SO helpful. It will make life easier.
Hayley

"Max" wrote:

Line should read as:
Check Fixed decimal 2 places (say)


--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----



  #5   Report Post  
Max
 
Posts: n/a
Default

You're welcome, Hayley !
Glad to help
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Hayley" wrote in message
...
Max, thank you. That is SO helpful. It will make life easier.
Hayley



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
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. terrier New Users to Excel 1 January 29th 05 11:59 AM
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. terrier New Users to Excel 0 January 29th 05 07:11 AM
enter data in cell then run macro automatically R D S Excel Discussion (Misc queries) 2 January 25th 05 11:19 PM
Excel: How do I enter a date in one cell & automatically dates adj Shannon Excel Discussion (Misc queries) 4 January 12th 05 01:51 AM
Enter Data Into Another Excel File Automatically Morrisg Excel Worksheet Functions 0 January 11th 05 03:07 AM


All times are GMT +1. The time now is 12:41 PM.

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"