| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comma Delimited Numbers
Hi, I have received a file with a comma instead of a decimal point. How do i
convert 4,56 to 4.56? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comma Delimited Numbers
Replace all (Ctrl+H) "," with "."
"Spannerman" wrote: Hi, I have received a file with a comma instead of a decimal point. How do i convert 4,56 to 4.56? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comma Delimited Numbers
Thanks Amit,
This does not seem to work in excel when there are a large number of prices. There are some 8,000 prices where this change needs to occur. Is a formula required? "Amit GK" wrote: Replace all (Ctrl+H) "," with "." "Spannerman" wrote: Hi, I have received a file with a comma instead of a decimal point. How do i convert 4,56 to 4.56? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comma Delimited Numbers
Not even if you select them all then do it?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Spannerman" wrote in message ... Thanks Amit, This does not seem to work in excel when there are a large number of prices. There are some 8,000 prices where this change needs to occur. Is a formula required? "Amit GK" wrote: Replace all (Ctrl+H) "," with "." "Spannerman" wrote: Hi, I have received a file with a comma instead of a decimal point. How do i convert 4,56 to 4.56? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating CSV Comma Delimited File | Excel Discussion (Misc queries) | |||
| Totaling the number of comma delimited numbers in a column | Excel Worksheet Functions | |||
| Converting negative/positive numbers to a CSV (Comma-delimited .TX | Excel Worksheet Functions | |||
| Comma delimited question | Excel Discussion (Misc queries) | |||
| HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
Linear Mode
