Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dollar and date format
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
Moving numbers from one sheet to another by date | Excel Worksheet Functions |