Forum Discussion
Solved
Formatting a number that uses a carrot symbol as a decimal point
Hello all, I'd like to be able to format data that I'm pulling in from an external source. I need to format a number that uses the decimal point instead of the carrot symbol. the numbers from the s...
Hi
You can simply Use the Replace Dialog Box (Home Tab >> Find & Select >> Replace) Shortcut CTRL+H
- In the Find What type ^
- in the Replace With type . (period)
- Hit Replace All
Done
Hope that helps
Nabil Mourad
If you are satisfied with my solution, kindly mark it as an "Accepted Solution"
Thank you
Good Luck
Nabil Mourad