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
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
Great idea! I didn't know you could do that. It's not working in this application, I wonder if it's because it's a live data stream into excel. I'll keep messing with it to see what I can do.
Thanks for your help!
