FORMAT COLUMN

H

henry south

I HAVE A TEXT FILE THAT COMES IN TO EXCEL DELIMITED AND A VALUE COMES IN AT
20000 iS THERE A WAY TO TELL THAT COLUMN TO CHANGR THAT FORMAT TO 200.00
WITH OUT CREATING A NEW COLUMN WITH A FORMULA
 
D

Dave Peterson

You could put 100 in an empty cell
copy that cell
select that column to adjust
edit|paste special|click divide

Clean up that cell with 100 in it.
 
Top