Excel displayed format into an actual value

  Craig.m 12:10 25 Oct 2010
Locked

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

=TEXT(A1*100,"000000000000")

  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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?