Become a Certified GST Practitioner. Batch begins 18th Nov. Register Now!

Reg EXcel

Tanu (Accountant) (767 Points)

05 October 2010

Dear Frnz, tell me as i exported data from Busy software and there is a format of value in text form using ' thats why sum formulae is not working. please tell me any shortcut to remove that all sing of ' in front of every value so that sum formula cud work

Reply
Follow
Share

6 Replies

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 05 October 2010

SELECT THE ENTIRE COLUMN WHERE THERE IS ' SIGN PRESENT GO TO EDIT -FIND & REPLACE ( CTRL+H AND THEN IN "FIND WHAT" FIELD ENTER ' . AND KEEP REPLACE WITH FIELD BLANK AND THEN CLICK ON REPLACE ALL . MAKE SURE THAT ONLY REQUIRED COLUMN IS SELECTED .IF NOT EXCEL WILL REPLACE ALL ' SIGN FROM YOUR SHEET. IF YOU ARE NOT SURE THEN SAVE AS THE FILE AND TRY THIS IN NEW TEMPORARY FILE AND SEE IF IT WORKS OR NOT.

Upgrade to CAclubindia Pro. Subscribe Now!

Tanu (Accountant) (767 Points)
Replied 05 October 2010

I did also but nothing happened

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 05 October 2010

then your numbers are in date format.Select the cells containing such signs and change the format to numbers. Even if this doesn't work just let me know

Harpreet (* * * * * *) (1670 Points)
Replied 05 October 2010

Select the column in which you are seeing that kind of sign ( ' ) then insert one column parallel to this column. After that insert a formula i.e. =trim(cell) then enter.

Definitely you will get your problem sorted out.