What data do you have in the cells?
a. Hardcoded values
b. Existing formulae
"Rick" wrote:
I tried the multiply by 100, It works except I can't seem to figure out how
to apply a formula automatically to a column when the data is already there.
Solution 2 worked perfectly! - Thanks
"Ramakrishnan Rajamani" wrote:
For Question # 1 - Multiply by 100 :-)) Just kidding
For Question # 2 - Format Cells - Custom - mmddyyyy or mmddyyyy.
"Rick" wrote:
I have 2 questions related to formatting information that I have imported:
1)If I have a column that contains amounts such as 0000000427.99 and I want
to remove the decimal but keep the trailing cents, what is the best way to do
that for a whole column? example: 000000042799
2) I also have a date that has been imported as 3/9/2005 and I need to
remove the "/"'s and have the month and date format with zeros if needed such
as 03092005, what is the best way to accomplish this on a column.
Thank you,
Rick
|