Data Entry

[Chrisp]

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

 

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Chrisp]

Thanks, this is exactly what I needed.