Excel - Convert Text to Values

[reichertc]

Hi folks,

I often am given large quantities of data from a database, which has been put into an excel file. I am then asked to perform calculations based upon the data that has been dumped on me. The problem is that often the "numbers" come accross in Excel's text format. I would like to program a button onto my toolbar where I could select a range of cells, click the button, and have all text converted to values...

I struggle pretty hard with VBA, so any advice on how to do this would be appreciated.

 

[acron]

Try this :

Copy an empty cell.

Select you range to convert. From the Edit menu select PasteSpecial, and under the Operation section select Add

If you want any formatting to apply to the converted data, apply such formatting to the blank cell before you copy it.

You could also copy a cell with a value of 1 (also formatted as required) and instead of Add select Multiply.

A.C.