| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text as number
i have received a spreadsheet with some numbers which seem to be entered as
text. i am not able to convert them back to numbers with =value(text). can someone please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as number
--Copy a blank cell
--Select the range of numbers (to be converted) in your spreadsheet --Right clickPasteSpecialSelect Add. and click OK If this post helps click Yes --------------- Jacob Skaria "a m spock" wrote: i have received a spreadsheet with some numbers which seem to be entered as text. i am not able to convert them back to numbers with =value(text). can someone please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as number
Hi,
Select the range and then go to Data Text columns. Just click on Finish -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "a m spock" wrote in message ... i have received a spreadsheet with some numbers which seem to be entered as text. i am not able to convert them back to numbers with =value(text). can someone please help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as number
did not work. here is copy of one cell:
4,76,258.33 "Ashish Mathur" wrote: Hi, Select the range and then go to Data Text columns. Just click on Finish -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "a m spock" wrote in message ... i have received a spreadsheet with some numbers which seem to be entered as text. i am not able to convert them back to numbers with =value(text). can someone please help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as number
=--SUBSTITUTE(A1,",","")
-- David Biddulph a m spock wrote: did not work. here is copy of one cell: 4,76,258.33 "Ashish Mathur" wrote: Hi, Select the range and then go to Data Text columns. Just click on Finish -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "a m spock" wrote in message ... i have received a spreadsheet with some numbers which seem to be entered as text. i am not able to convert them back to numbers with =value(text). can someone please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Linear Mode
