View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
His child His child is offline
external usenet poster
 
Posts: 1
Default need some columns to auto add decimal pt & others to not - How to.

I have a spreadsheet that in one column I enter a number that will not have
decimal places. The next column are number with 2 decimal places. The 3rd
column multiplies the 1st 2 and has 2 decimal places. Is there a way to
enter the figures in the 2nd column that the computer would add the 2 decimal
places without my having to input the decimal. There is alot of data and it
would be quicker if this was possible.