Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Text Format
I have a column of numbers formatted as text such as:
099.600 '101.550 102.000 '104.430 105.500 Some numbers have an apostrophe in front and some do not. I would like to make all the numbers in this column consistent without the apostrophe. I would also like to keep them as text since converting them to numbers would likely get rid of the first character for numbers less than 100. What is the best way to accomplish this? Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Text Format
You could create a helper column. Use the formula =TEXT(A2,"000.000").
copy/paste the formula next to all of your data, then copy and paste the values of the formulas. "evoxfan" wrote: I have a column of numbers formatted as text such as: 099.600 '101.550 102.000 '104.430 105.500 Some numbers have an apostrophe in front and some do not. I would like to make all the numbers in this column consistent without the apostrophe. I would also like to keep them as text since converting them to numbers would likely get rid of the first character for numbers less than 100. What is the best way to accomplish this? Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Text Format
First, select all of the cells with these numbers in them, then format your
cells as text, then press Alt+F11 and execute this statement in the Immediate window (press Alt+G if you don't see the Immediate window)... Selection.Value = Selection.Value -- Rick (MVP - Excel) "evoxfan" wrote in message ... I have a column of numbers formatted as text such as: 099.600 '101.550 102.000 '104.430 105.500 Some numbers have an apostrophe in front and some do not. I would like to make all the numbers in this column consistent without the apostrophe. I would also like to keep them as text since converting them to numbers would likely get rid of the first character for numbers less than 100. What is the best way to accomplish this? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
How to change text format .126 to number format 0.126 ? | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |