Justplainj
New Member
- Joined
- Apr 15, 2021
- Messages
- 47
- Office Version
- 365
- Platform
- Windows
Hi All,
Using office 365 dekstop.
I am sure this is a quick and easy fix for some but for some reason I cannot figure it out.
Tried searching other posts but no fix is unique to my problem.
I am having a #VALUE error can cannot find a quick way to fix it.
The reason it happens is because: Column A I have a value that is extracted from a reporting program which is read as example, 22 325.00 . It has a space after the first 22 and a space at the end due to custom formatting applied by the reporting program which the author of the program cannot seem to fix.
Column B I multiply the value in column A by a tax i.e. =A2*1.15 to add 15% tax.
I have tried the following in column A to try and change the formatting.
Removing spaces with Find & Replace function.
Using trim(), value() functions
Formatting to number formatting
Formatting to custom formatting.
The space at the end after the .00 never seems to go away
I am resorting to selecting the cell, removing the space at the end manually for each cell.
Problem, I have over 600k cells.
Is there any other quick way to solve this?
Having to do this every time a new report is drawn is a nightmare.
Thank you,
Using office 365 dekstop.
I am sure this is a quick and easy fix for some but for some reason I cannot figure it out.
Tried searching other posts but no fix is unique to my problem.
I am having a #VALUE error can cannot find a quick way to fix it.
The reason it happens is because: Column A I have a value that is extracted from a reporting program which is read as example, 22 325.00 . It has a space after the first 22 and a space at the end due to custom formatting applied by the reporting program which the author of the program cannot seem to fix.
Column B I multiply the value in column A by a tax i.e. =A2*1.15 to add 15% tax.
I have tried the following in column A to try and change the formatting.
Removing spaces with Find & Replace function.
Using trim(), value() functions
Formatting to number formatting
Formatting to custom formatting.
The space at the end after the .00 never seems to go away
I am resorting to selecting the cell, removing the space at the end manually for each cell.
Problem, I have over 600k cells.
Is there any other quick way to solve this?
Having to do this every time a new report is drawn is a nightmare.
Thank you,