Thread: Cell format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
ranswert ranswert is offline
external usenet poster
 
Posts: 161
Default Cell format

Thank You

"CLR" wrote:

You need to do two things,
Select the cell, Right-click FormatCells NumberTab Currency ok

then
Data Validation Allow: Decimals then set your limits and click OK

Vaya con Dios,
Chuck, CABGx3



"ranswert" wrote:

How do I format a cell for currency and make it so that it wouldn't accept
anything but a number?
Thanks