Excel displayed format into an actual value

  Craig.m 12:10 25 Oct 2010

I require a Pounds value to be converted into a 12 digit number with leading zeros and the decimal point removed, I managed to display £350.50 as 000000035050, by the format 000000000000 and then muliply the figure by 100.

The problem with the above is that it is to be used to feed another system so it needs to actually have the content of 000000035050, how can I transpose a large list of £s values into this format, I suppose the multiply by 100 is easy enough but how do I then take the resultant number and rather than display it as the 12 digits above make cell content be that, this is so that the system feeding it will recognise it?

  VoG II 12:15 25 Oct 2010

In a spare column try like this


  Craig.m 12:35 25 Oct 2010

Exactly what I wanted, a lot simpler than I thought, thanks VoG

  Zak 13:42 25 Oct 2010

Cell A1 is formatted Accounting with £
Format the cell B1 as Custom format 000000000000
Formula in Cell B1 = A1
All other cells requiring a 12 digit number need to be formatted with Custom format 000000000000 as above.

I take it that "the system feeding" it is in Excel?

  Zak 13:43 25 Oct 2010

Late again, I went off to watch the news and did not refresh page!!

  Zak 13:46 25 Oct 2010

and wrong!!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?