If you enter 6 and it appears as 0.06 you have Excel set up to automatically add decimal places.

Change that like this depending on your Excel version:

Excel 2010 - Click on File Menu at top left - select "Excel Options" then go to "Advanced" and under "Editing Options" untick the "automatically insert a decimal point" option.

Excel 2007 - Click on Office button at top left - select "Excel Options" then go to "Advanced" and under "Editing Options" untick the "automatically insert a decimal point" option.

In Excel 2003 and earlier versions you can access this option through Tools > Options > Edit > untick "Fixed decimal Places"

Once you have done that make sure your cells are formatted to General or number (zero decimal places) and when you enter 6 you will see just 6.....