Putting single inverted comma before a digit in Excel

Shashank tiwari

New Member

Join Date: Oct 2007

Posts: 1
#1

Putting single inverted comma before a digit in Excel

Oct 14 '07, 10:29 AM

Hi

I am trying Putting single inverted comma before a digit in Excel and a single inverted comma after the number and a comma to follow. Eg. '234567',

Can anybody tell us how to do it for 7000 records

Thanks
Tags: None
pbmods

Recognized Expert Expert

Join Date: Apr 2007

Posts: 5821
#2

Oct 14 '07, 03:31 PM

Heya, Shashank. Welcome to TSDN!

Check out this article.
Comment

Comment