R ranswert Jan 14, 2008 #1 How do I format a cell for currency and make it so that it wouldn't accept anything but a number? Thanks
How do I format a cell for currency and make it so that it wouldn't accept anything but a number? Thanks
C CLR Jan 14, 2008 #2 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
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
R ranswert Jan 14, 2008 #3 Thank You CLR said: 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 Click to expand...
Thank You CLR said: 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 Click to expand...
C CLR Jan 14, 2008 #4 Happy to help..............thanks for the feedback. Vaya con Dios, Chuck, CABGx3
