S
sue t
Hello:
I am using Excel 2003, and work with #'s that are imported
from another data base. How do I set the numbers
formating so I can just highlight the entire column and
change it instead of re-entering all the numbers?
Example:
Comes over as 1,217,000 I want it to be 1,127
or 12,217,600 I want 12,128. I have tried to set it as a #
with no decimal places. Even looked in custom? I amd
stumped on this one!
Thank You for any help you can give me
I am using Excel 2003, and work with #'s that are imported
from another data base. How do I set the numbers
formating so I can just highlight the entire column and
change it instead of re-entering all the numbers?
Example:
Comes over as 1,217,000 I want it to be 1,127
or 12,217,600 I want 12,128. I have tried to set it as a #
with no decimal places. Even looked in custom? I amd
stumped on this one!
Thank You for any help you can give me