R
ranswert
How do I format a cell for currency and make it so that it wouldn't accept
anything but a number?
Thanks
anything but a number?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
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
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
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
C
CLR
Happy to help..............thanks for the feedback.
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3