Converting to number format does not work correctly

Executioner

Board Regular
Joined
Sep 26, 2005
Messages
166
I have a seperate application were I export data to an Excel spreadsheet. Everything comes over correctly except for number formatting. It has nothing to do with the number format itself, but how Excel treats the number. They look like this which is visually correct on the screen:
0.50
0.25
0.50
0.75
1.25
0.75
0.75
0.75
0.50
0.25

If I select this column of numbers in order to format them to NUMBER, Excel does not process the numbers to NUMBER format. The reason I can tell they are not in number format is either by adding them, or even simply selecting these numbers ahd watching the SUM total in the bottom of the Status Bar. Nothing is displayed totaling the values.

In order for me to make it work, I have to convert it to TEXT first, then select NUMBER. At this point, it's still not a number. I then have to double-click the cell, then click away to another cell, and finally, Excel converts it to a number format.

Is there any way this can be done faster than double-clicking on each cell individually? I have almost 1000 rows of data to process.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
Try ASAP Utilities

www.asap-utilities.com

or in an empty cell enter 1, click copy, highlight the range and go to Edit/Paste Special, tick Multiply.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,931
Office Version
  1. 365
Platform
  1. Windows
Or Data>Text to Columns...:)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,406
Messages
5,547,759
Members
410,811
Latest member
adustin42
Top