copying custom formated #'s

  • Thread starter Thread starter keyur
  • Start date Start date
K

keyur

Hi!

I have a column of custom formated #'s so 111 looks
like 'R1 S1-1'. When i linked the table to acess, it just
shows 111. I dont want to type all of it individually. is
there any other way i can change all of them?
thanks
 
Hi
you may use a helper column. If your data is in column a enter the
following in B1
=TEXT(A1,"""R""0 ""S""0-0")
and copy down
 
Hi
your custom format probably looks like
"R"0 "S"0-0

The TEXT function expects a string as second parameter enclosed in "
signs. To make Excel recognize the " of the custom format you need to
double them. So in your case
" " " R " " (I included spaces for visibilty) does the following:
- the first " is for starting the format string
- the 2nd and 3rd " are used to produce a single " as output
 
Back
Top