View Single Post
 
Old 02-19-2014, 08:30 AM
fieldhaven fieldhaven is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2014
Posts: 2
fieldhaven is on a distinguished road
Default Problem Solved

I figured out the issue. It seems that even though I had formatted the columns as text Excel was still seeing the cells as numeric. So when I replaced 244 with 244.0 the "0" was truncated in spite of the text format. I changed my replace statement to '244.0 and it now works. I've attached a print screen to illustrate the before/after.

Thanks!
Attached Files
File Type: docx Find and Replace Codes.docx (86.4 KB, 11 views)
Reply With Quote