Currency and text issue

[Noxqss38242]

How do I keep my data in a column with $5,450.50 and still have my text cells in the same column as they are without returning "error".

 

[etaf]

why are you getting an error , is that because you are formatting the column to text ?

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[Noxqss38242]

Maintenance Report.xlsx
	N	O	P
78	0	1	Over 24 Hours:
79		Est
80		Est
81
82
83	0	2	Over 24 Hours:
84		Est
85		War
86		Est
87
88	3		Over 24 Hours:
89	Notes	Est	Reason Down
90	Repairs Continue	9264.64	Breakdown
91	Repairs Continue	War	Breakdown
92	Pnd Further Diag	War	Unplanned
93
94	4		Over 24 Hours:
95	Notes	Est	Reason Down
96	Pnd Parts	War	Breakdown
97	Diag Continues	700	Planned
98	Pnd Extended Diag 5/26	War	Breakdown
99	Pnd Est Review	War	Breakdown
100
101	3		Over 24 Hours:
102		EST
103		45411
104		2379
TRUCKS

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A33:S114,A116:S1163,A115:N115,P115:S115	Expression	=$A33="UNIT"	text	NO
B33:S114,B116:S712,B115:N115,P115:S115	Expression	=SEARCH("Laredo",$A33)	text	NO
O34:O114,O116:O264,P115	Expression	=SEARCH("Repair Notes",$N34)	text	NO
P33:P786	Expression	=SEARCH("Murray",$N33)	text	NO
O33:O114,O116:O633,P115	Expression	=SEARCH("Total",$M33)	text	NO
N33:N734	Expression	=SEARCH("Total",$M33)	text	NO
O33:O114,O116:O701	Expression	=SEARCH("Quick",$O33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Loaner",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Empty Trucks",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Tractors",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Road Repairs",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Indianapolis",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("West",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("Murray Shop",$A33)	text	NO
B33:S114,B116:S918,B115:N115,P115:S115	Expression	=SEARCH("AVAILABLE",$A33)	text	NO
A33:S114,A116:S881,A115:N115,P115:S115	Expression	=ISBLANK($A33)	text	NO

Using Power Query, in the column with "EST" for estimate, I was tasked to see if instead of 9264.64 it can read $9,264.64 and so forth....but when I change the column to accounting, Power Query changes the text in that column to "error"