Skip to primary content
Skip to secondary content

Easy-Excel.com

Find Easy Solutions to Your Excel Problems!

Main menu

  • Home
  • About
    • About me
    • About this blog
    • Privacy Policy
  • Cookie Policy
  • Excel in Other Languages
    • Excel Functions in Catalan
    • Excel Functions in Czech
    • Excel Functions in Danish
    • Excel Functions in Dutch
    • Excel Functions in Finnish
    • Excel Functions in French
    • Excel Functions in Galician
    • Excel Functions in German
    • Excel Functions in Hungarian
    • Excel Functions in Italian
    • Excel Functions in Norwegian
    • Excel Functions in Polish
    • Excel Functions in Portuguese (Brazilian)
    • Excel Functions in Portuguese (European)
    • Excel Functions in Russian
    • Excel Functions in Spanish
    • Excel Functions in Swedish
    • Excel Functions in Turkish
    • Excel Functions Translator add-in
  • Useful Shortcuts

Tag Archives: Copy Format

How to Copy Format in Excel

Posted on August 22, 2013 by Audun Danielsen
Reply

Sometimes some of the data in a table have the wrong format. Take a look at this table, where some of the records are in hh:mm format, and others in hh:mm:ss format.

EasyExcel_38_1_Copy format in Excel

Here is an easy way to fix it:

READ MORE

Posted in Easy Tricks | Tagged Copy Format, easy excel, Excel | Leave a reply

Categories

  • Charts (4)
  • Conditional Formatting (6)
  • Date & time (4)
  • Easy Tricks (40)
  • Macros (2)
  • Number Formatting (1)
  • Shortcuts (8)
  • Text Functions (6)
  • Tutorials (16)
  • Useless Tricks (2)

Recent Posts

  • How to get Unique values in Excel with one simple formula: UNIQUE
  • How to include the measurement unit in the number format in Excel
  • How to handle tables with empty cells in Excel
  • SUM across multiple sheets in Excel
  • Make SUMIFS and COUNTIFS in Excel more flexible with a Wildcard
  • Summarize a whole table in Excel without writing a formula
  • The easiest way to reduce file size in Excel: Excel Binary Workbook
  • An easier way to calculate compound interest in Excel
  • How to find cells that contain a formula in Excel
  • Unhide all sheets in Excel with a simple macro that works for all your documents

Blogroll

  • Chandoo
  • Excel Shortcuts
  • Excelcharts.com
  • Excelisfun Youtube-channel
  • Mr. Excel Youtube-channel
Privacy Policy Proudly powered by WordPress