Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My number shows as text
I have a series of numbers which show as text. How do I convert the field to
a number? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My number shows as text
hi Funkyfido,
The following assumes you mean numbers formatted as text (i.e. they're left-aligned). First off, make sure the cells are formatted with the appropriate numeric format. Next, in an unused cell, enter a '1'. Then, copy that cell, select the errant cells and use Edit|Paste Special|ValuesMultiply. Cheers -- macropod [MVP - Microsoft Word] "Funkyfido" wrote in message ... | I have a series of numbers which show as text. How do I convert the field to | a number? | | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
how i change thai text to english text | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions |