In the cell my number looks like 6-61120-20444 but in the formula bar it looks like 6112020444. How can I change it to look like 6-61120-20444 in the formula bar? It was suggested that I develop a marco to fix this but I can't seem to get one that will work, any ideas. Thank you.
with 6112020444 in a1 in b1 =TEXT(A1,"0-00000-00000") fill down
now copy column b and paste back special/values you can then either delete column a or paste over column a and delete b
"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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks