Thread: display error
View Single Post
 
Old 08-02-2013, 12:11 AM
jolinchew jolinchew is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jul 2013
Posts: 11
jolinchew is on a distinguished road
Default display error
display error, I want to change column U, for example from 4.000002E13 to 40000165342013, pls see attached. how to do? why it display like ***2E13, how to prevent this.

also if I have cell "12345672013", how to make it by trail 2013 in the cell, I want it to be "1234567"
Attached Images
File Type: png 2013.PNG (7.6 KB, 10 views)
Reply With Quote