| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a string of numbers in to number format
I have pulled numbers out of a string that I imported and cannot get it to
format when I chose number with a comma and red for credits in the pull down format cells menu. Is there a funtion that would make formating the numbers possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change a string of numbers in to number format
Did you use a formula to extract these numbers? (RIGHT, LEFT, MID, etc...)
If so, then the returned value is probably text, regardless of how the cell is formatted. To get around this, try placing your formula inside the VALUE() function. Something like: =VALUE(RIGHT(A1,2)) This will convert the text to a number, then your cell formatting should be applied correctly. HTH, Elkar "Debi" wrote: I have pulled numbers out of a string that I imported and cannot get it to format when I chose number with a comma and red for credits in the pull down format cells menu. Is there a funtion that would make formating the numbers possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Big background page numbers/ Can't change format of a range | New Users to Excel | |||
| Why does Excell change my last number to "0" in a string? | Excel Discussion (Misc queries) | |||
| can I delete the 1st number from a string of numbers | Excel Discussion (Misc queries) | |||
| Hoe to change text format .126 to number format 0.126 | Excel Discussion (Misc queries) | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Linear Mode
