View Single Post
 
Old 04-18-2018, 08:05 AM
goingvirtual goingvirtual is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 9
goingvirtual is on a distinguished road
Default Changing text to number format

I copied data from a table into Excel, and when I tried to multiply two numbers together, it results in "#VALUE!". I thought that probably means that the numbers are formatted as text, so I've tried:
  1. Removing commas using find and replace
  2. Using the "Trim" function to remove spaces
  3. Using the "Value" function to change from text to numerical formatting

However, I'm still getting the same #VALUE! result when I try to perform mathematical operations using this data. Any suggestions?

Thanks,
Mike
Reply With Quote