My boss ask me to convert to text format some files of previous encoded excel project, right now i am re-encoding them and there are tons of them. this is more or less how it looks like
A B C
1 5 7
2 8 56
3 10 5
what is needed is like this:
A B C
1 05 07
2 08 56
3 10 05
Is there an easy way to do this and the final format of the sheet is in text format?
Thanks!
Last edited by grue; 10-07-2012 at 12:38 PM.
Use
=TEXT(B1,"00")
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
put say a few columns over =TEXT(A1,"00") drag across and down to you have reproduced your range,yo can then copy past special over the original,
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Woooh!!!
Thanks very very much for the help. It made work so so very easy!
Added good reps =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks