I Need Help

[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?

 

[ben]

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