I Need Help

  • Thread starter Thread starter Henry H
  • Start date Start date
H

Henry H

For whatever reason when I import certain text files, the
numbers in certain cells come up for example: 24,00 which
excel doesn't recognize. How do I tell the spreadsheet
that any cell that has two digits after a comma to add
another zero at the end?
 
I am not sure if this helps you, but when you select a
cell (or range of cells) hit ctrl+1 or go to format/cells

the dialog box lets you customize the cell, the first tab
is number and this lets you select the type of cell, like
number/text etc. under number it let's you select the
decimal numbers desired after a comma.

Ben
 
Back
Top