Changing a number stored as text to a value and vice versa +

Siswell

New Member
Joined
Oct 30, 2004
Messages
40
Like the title says does anyone know how to easily and simply change a number stored in as text to a value and vice versa. I know you can change a value to number by copying it then using the special paste to a new cell, and i also know you can turn value into text by adding a ' at the start.
Need this as i'm using a vlookup command which doesn't see that the text is the same as a value, also using an old version of Excel so the drop down options for cells don't appear.

Also does anyone know any good guides for pivot tables as i'm a complete newbie on them and wish to figure out what they do.

Oh and last but not least how can you remove named fileds, eg NameofField=A1:C3 <- needs removing so i can use the name for some other field/range/array.
 

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.

Forum statistics

Threads
1,148,396
Messages
5,746,452
Members
424,020
Latest member
LongDoo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top