View Single Post
  #3   Report Post  
Old February 12th 07, 09:30 PM posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2,574
Default Question For Importing Data Into Excel/Converting General Number t

One way would be to divide the values in the cells by 100. 303,000/100 =
303, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


" wrote:

Hi,

I know how to import data into Excel. However, one of my colums is a
number field where i need the number in the cell to be displayed as a
dollar amount...

Say the cell reads H1 reads 30300. I need that cell to read 0303.00

How do I do that without having to manually go into each cell (we are
talking 1500 cells) and adding a zero and putting a decimal in?