Hi Guys
Trying to put 116192031,116195031 into excel but keep getting 116,192,031,116,195,000.
I have tried all of the options in formatting but cannot think of a way to get this right. I need it correct for upload to another system and must be correct.
Any ideas please. You would make my day
Thanks
neil
format cell as text first then input data
"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
Do you have any macros in the worksheet, right-click tab and click View Code.. is there any that might be causing this formatting?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Place an apostrophy at the beginning may work.
Last edited by davesexcel; 11-04-2010 at 06:51 PM.
Please adapt your title to something usable for the forum's search function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks