Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
i have received a spreadsheet in which some numbers appear to be entered as
text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
What do these numbers look like? Is there a single apostrophe at the
beginning of them (i.e. a ' )? Please provide an example of your data. Have you tried formatting the cells as "Number"? Are they currently formatted as "Text" or "General"? Eric "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
thanks
1. this is a copy : 4,76,258.33 2. there are no aostrophes. 3. i have tried reformatting is there any other way i can send a copy of a part of the spreadsheet itself? i am going mad. "EricG" wrote: What do these numbers look like? Is there a single apostrophe at the beginning of them (i.e. a ' )? Please provide an example of your data. Have you tried formatting the cells as "Number"? Are they currently formatted as "Text" or "General"? Eric "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
Sub test() Dim rng As Excel.Range Set rng = [a1:a10] rng.Value = rng.Value End Sub regards r Il mio ultimo lavoro ... http://excelvba.altervista.org/blog/...ternative.html "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
Format to General
--Hit Ctrl+H (Replace window) --From replace window find , (comma) replace (blank) --Hit OK If this post helps click Yes --------------- Jacob Skaria "a m spock" wrote: thanks 1. this is a copy : 4,76,258.33 2. there are no aostrophes. 3. i have tried reformatting is there any other way i can send a copy of a part of the spreadsheet itself? i am going mad. "EricG" wrote: What do these numbers look like? Is there a single apostrophe at the beginning of them (i.e. a ' )? Please provide an example of your data. Have you tried formatting the cells as "Number"? Are they currently formatted as "Text" or "General"? Eric "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
Looks like you have extra commas in your numbers. As Jacob shows, try
getting rid of all the commas first using the Replace command. Select the entire range, then Edit/Replace... In the "Find what:" box, type a "," (comma) In the "Replace with:" box, type nothing (leave it blank) Press the "Replace All" button. Then format those cells either as General or Number. HTH, Eric "a m spock" wrote: thanks 1. this is a copy : 4,76,258.33 2. there are no aostrophes. 3. i have tried reformatting is there any other way i can send a copy of a part of the spreadsheet itself? i am going mad. "EricG" wrote: What do these numbers look like? Is there a single apostrophe at the beginning of them (i.e. a ' )? Please provide an example of your data. Have you tried formatting the cells as "Number"? Are they currently formatted as "Text" or "General"? Eric "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
thanks. just tried it.
it deilvers #VALUE! "r" wrote: Sub test() Dim rng As Excel.Range Set rng = [a1:a10] rng.Value = rng.Value End Sub regards r Il mio ultimo lavoro ... http://excelvba.altervista.org/blog/...ternative.html "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
many thnaks. you have cured hours of frustration. "Jacob Skaria" wrote: Format to General --Hit Ctrl+H (Replace window) --From replace window find , (comma) replace (blank) --Hit OK If this post helps click Yes --------------- Jacob Skaria "a m spock" wrote: thanks 1. this is a copy : 4,76,258.33 2. there are no aostrophes. 3. i have tried reformatting is there any other way i can send a copy of a part of the spreadsheet itself? i am going mad. "EricG" wrote: What do these numbers look like? Is there a single apostrophe at the beginning of them (i.e. a ' )? Please provide an example of your data. Have you tried formatting the cells as "Number"? Are they currently formatted as "Text" or "General"? Eric "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
number not recognised
Regional settings have to match the number format and vice versa. If you
use European number format, the regional settins must be set to accomodate that format. "a m spock" wrote in message ... thanks. just tried it. it deilvers #VALUE! "r" wrote: Sub test() Dim rng As Excel.Range Set rng = [a1:a10] rng.Value = rng.Value End Sub regards r Il mio ultimo lavoro ... http://excelvba.altervista.org/blog/...ternative.html "a m spock" wrote: i have received a spreadsheet in which some numbers appear to be entered as text. i have tried the =value(text) function but am not able to convert them back to numbers. please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates not recognised | Excel Discussion (Misc queries) | |||
UserInterfaceOnly not being recognised | Excel Programming | |||
cell value not recognised | Excel Programming | |||
Excel VBA not recognised | Excel Programming | |||
Name not recognised | Excel Programming |